Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hilus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hilus8481764(None) 
hills85431351hills
hilts86924411hilts
hilum105514601hilum
pilus75921061pilus
ails45654712ail_s
biles75542142biles
bilks115117892bilks
bills75632862bills
bolus79125542bolus
chiaus113611302chiaus
chiles115425302chiles
chilis115517872chilis
chills114717702chills
chirus114615692chirus
dills65530972dills
ficus105015492ficus
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
filum105015432filum
flus75626542_flus
gilds75417522gilds
gills64728192gills
gilts64924262gilts
habus106317142habus
haikus13538292haikus
hails85231642hail_s
hakus125114112hakus
hales85449842hales
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
hauls86123732hauls
heils85222192heil_s
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
hiatus938222hiatus
hicks145322172hicks
hides95129422hides
hies74842832hi_es
highs125412522highs
hikes125426982hikes
hila76228352hil_a
hilar85418142hilar
hili75626632hil_i
hill76439492hil_l
hillo84721652hillo
hillos94618882hillos
hilly114422162hilly
hilt75850712hil_t
hims95230972hi_ms
hinds96721472hinds
hins76447992hi_ns
hints87330622hints
hips96433702hi_ps
hires86134342hires
his66359502hi__s
hiss75629212hi_ss
hists86328372hists
hits75545132hi_ts
hives116925512hives
hocus104715202hocus
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
humus106215072humus
hylas114815902hylas
iglus6609932iglus
ileus54616892_ileus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
lieus56218482lieus
lilos55821872lilos
lilts55822802lilts
lulus54315162lulus
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mil_s
milts75430712milts
minus75223932minus
nidus65913572nidus
nills54926672nills
nils46132452nil_s
nisus56014392nisus
oils46337972oil_s
pilaus84114132pilaus
piles74742612piles
pileus84514942pileus
pilis75825202pilis
pills74130972pills
pilous84717752pilous
pious74621272pious
plus66324832_plus
poilus82210572poilus
riles55343642riles
rills55032712rills
risus54216392risus
shills94519602shills
silds65520522silds
silks94620682silks
sills55135982sills
silos56029422silos
silts55330822silts
sinus55523852sinus
situs55019232situs
solus54726982solus
sulus54821882sulus
talus55423262talus
thills95515382thills
tiles55542102tiles
tills54631702tills
tils45739612til_s
tilts55325612tilts
tolus55024482tolus
ulus45622562_ulus
vills86429322vills
villus93611222villus
virus85316842virus
whiles124418012whiles
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
yills83921552yills
zills144020782zills

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.0931921408.6
2DLD Change Limit538001461.72031279.1
3Display Results1461460.0463173.9
 (SQL Overall)1786911461.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.