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 “ills” 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.

262 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
ills4703042(None) 
alls46740921alls
bills75632861bills
dills65530971dills
ells46431351ells
fills84632371fills
gills64728191gills
hills85431351hills
ilks87218571ilks
ill37437091ill_
illy76925331illy
jills125122821jills
kills94526171kills
mills75435051mills
nills54926671nills
pills74130971pills
rills55032711rills
sills55135981sills
tills54631701tills
vills86429321vills
wills84528961wills
yills83921551yills
zills144020781zills
aals49941142aals
ails45654712ails
alas46358122alas
albs68628572albs
ales47067102ales
all36148232all_
ally76935642ally
alms65834922alms
alps65529242alps
als36663022_als
alts46639902alts
awls75926092awls
balls76236412balls
bals66354042bals
bells76432162bells
bels66142492bels
biles75542142biles
bilks115117892bilks
bill67239932bill_
billy105525362billy
birls74023162birls
bolls75531312bolls
brills84916292brills
bulls75629572bulls
calls75634732calls
cells75428062cells
cels65534972cels
chills114717702chills
cols66553082cols
culls75425812culls
dals57145122dals
dells66630942dells
dels56745472dels
dials64925342dials
dill55239972dill_
dilly94923782dilly
diols65521012diols
dirls64720502dirls
dolls66126922dolls
dols56943052dols
drills74414202drills
dulls64523742dulls
eels46536742eels
elds56324852elds
elks85820032elks
ell36735682ell_
elms67322702elms
els37645722_els
falls85727652falls
fells85327382fells
files85441272files
fill75540192fill_
fille84327402fille
filles94224522filles
fillo84319782fillo
fillos94415072fillos
filly114424902filly
films105617962films
filos86125382filos
fils75838692fils
flus75626542flus
frills94414222frills
fulls84623522fulls
galls64729322galls
gals57946502gals
gels56836102gels
gilds75417522gilds
gill56336182gill_
gilly94321632gilly
gilts64924262gilts
girls64518392girls
grills74314802grills
gulls65222982gulls
guls55930852guls
halls85633782halls
hells85032042hells
hill76439492hill_
hillo84721652hillo
hillos94618882hillos
hilly114422162hilly
hilts86924412hilts
hilus84817642hilus
hols76946292hols
hulls84923562hulls
ibis66519562ibis
ices66129642ices
ichs96214712ichs
ides57734232ides
idle55423762idle
idles66720122idles
idly85617322idly
idols65514132idols
ids47535462i_ds
idylls10425252idylls
idyls9498802idyls
ifs67124242i_fs
iggs66612672iggs
iglu510814782iglu
iglus6609932iglus
ilea45931462ilea
ileus54616892ileus
ilex115822032ilex
ilia46026812ilia
ilk78325302i_lk
ilka87215152ilka
iller54821292iller
illest63615722illest
imps86221112imps
inks86926502inks
inly75622212inly
inns46920932inns
ins35945602i_ns
ions46737852ions
ires45639282ires
iris45732542iris
irks86220132irks
is27048212i__s
isle45121702isle
isles54220562isles
isms66213472isms
its35538832i_ts
iwis77117002iwis
jells125522162jells
jill116430262jill_
jilts124717412jilts
kill85533172kill_
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
krills104211282krills
lalls55324132lalls
las37281472_las
les35663072_les
libs66732752libs
lids56336452lids
lies46454192lies
lilo46731562lilo
lilos55821872lilos
lilt46349942lilt
lilts55822802lilts
lily76730182lily
lins47059052lins
lips67141442lips
lis37162272_lis
lits46252492lits
lolls512121732lolls
lulls54119652lulls
maills84215282maills
malls76233432malls
mells75031332mells
mels65941532mels
milds86422052milds
miles74645072miles
milks115020582milks
mill66541472mill_
mille75029132mille
milles84526562milles
milos75428012milos
mils66045322mils
milts75430712milts
molls75129782molls
mols65948572mols
mulls75124152mulls
nill45634302nill_
nils46132452nils
nulls55019982nulls
oils46337972oils
olds55926572olds
oles46453472oles
olla44821172olla
ollas54218282ollas
owls76022932owls
palls74332562palls
pals66951352pals
piles74742612piles
pilis75825202pilis
pill65339462pill_
pilus75921062pilus
plus66324832plus
polls74627722polls
pols66044562pols
prills84015612prills
pulls74425052pulls
puls65437562puls
quills153811842quills
rials55026672rials
riels55121332riels
riles55343642riles
rill45140902rill_
rille55728732rille
rilles64725502rilles
rolls55326232rolls
sals46851672sals
sells55134432sells
sels46345982sels
shills94519602shills
sials54227242sials
silds65520522silds
silks94620682silks
sill45545152sill_
silly84527612silly
silos56029422silos
silts55330822silts
skills104313912skills
sols45448162sols
spills84717452spills
stills64118562stills
swills94213352swills
talls55133432talls
tells55828942tells
tels46841692tels
thills95515382thills
tiles55542102tiles
till45941202till_
tils45739612tils
tilts55325612tilts
tirls54519802tirls
tolls54728432tolls
trills64319852trills
twills9489792twills
ulus45622562ulus
vials85822382vials
vill75235072vill_
villa85321232villa
villas96117262villas
villi86517852villi
villus93611222villus
viols86118102viols
virls85618602virls
walls85529382walls
wells85426192wells
wilds94818202wilds
wiles85437872wiles
will75737512will_
willy115321912willy
wilts85023502wilts
yells85821942yells
yill75628972yill_
zill135727612zill_

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 Filter178691298720.0802233637.5
2DLD Change Limit298722620.82636164.6
3Display Results2622620.0634158.7
 (SQL Overall)1786912620.969184407.6
 
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.