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

165 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
loiter6461917(None) 
goiter74116201goiter
liter54736341l_iter
lofter94614721lofter
loiters74116611loiters
looter64222321looter
lotter64025601lotter
baiter84422552baiter
biter75030032_biter
bloater94013422bloater
blotter94612852blotter
boater84622092boater
boiler84319272boiler
boite74426322boite_
boites84322702boites
bolter83920752bolter
citer74827322_citer
cloister1037092cloister
clouter93511682clouter
coater84329552coater
coiler84421592coiler
coiner84323782coiner
cointer93616722cointer
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930202couter
doited85016632doited
doter65428622do_ter
dotier73917032dotier
dotter74419342dotter
eloiner7149182eloiner
floater104413352floater
flouter104311342flouter
footer94320772footer
foster94322222foster
gaiter73819502gaiter
gloater83711012gloater
goiters84014432goiters
goitre7349002goitre
hoister103714202hoister
hooter94123922hooter
hotter94720072hotter
joiner134114132joiner
jointer14379712jointer
jolter133513092jolter
jotter134315632jotter
kiter95523212_kiter
laster64830632laster
later54843922l_ater
latter65027892latter
lefter93613432lefter
leister73212752leister
letter63722582letter
liber74723622l_iber
lier45942462l_i_er
lifer85822152l_ifer
lifter93814812lifter
liger65024472l_iger
liker95627062l_iker
limiter92710852limiter
liner55938922l_iner
linter64625342linter
lister64527252lister
lite47054542l_ite_
liters65429872l_iters
lither94520952l_ither
litre55421462l_itre
litter64324852litter
liver85132962l_iver
loader74316302loader
loafer93610942loafer
loaner64416502loaner
loather103711002loather
lobber104016602lobber
lobster9288852lobster
locater93113602locater
locker124019422locker
lodger86517682lodger
lofted103811892lofted
lofters103912902lofters
loftier1037762loftier
logger86420002logger
logier75015732logier
loided83414022loided
loitered938182loitered
loiterer837082loiterer
loller63315282loller
loner55431042lo_ner
longer75823202longer
looker104816952looker
looper83817112looper
looser65219942looser
looted74421112looted
looters74419162looters
loper75129232lo_per
lopper103717202lopper
lorimer937752lorimer
loriner7511882loriner
loser54728672lo_ser
lotte54923852lotte_
lotted74222402lotted
lotters73921062lotters
lottery10389832lottery
lottes65322752lottes
louder74414602louder
louted74920692louted
louver94110392louver
lover85526452lo_ver
lower85830412lo_wer
luster64023672luster
miter75734792_miter
moiler84017262moiler
moister94015372moister
molter84119422molter
mooter83921092mooter
niter55028972_niter
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
oiler54628282_oiler
otter54423972_otter
outer55633302_outer
oxter123414092_oxter
plaiter93615392plaiter
plotter94113662plotter
pointer93814932pointer
poiser84217242poiser
politer92417072politer
porter84224412porter
poster84129172poster
potter83926982potter
pouter83923982pouter
powter114116032powter
rioter64817282rioter
roister73516202roister
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
slotter73314442slotter
smiter83616412smiter
softer94015312softer
sorter64425082sorter
souter64225922souter
suiter64121812suiter
titer55430612_titer
toiler63918282toiler
toited74016752toited
tooter64420802tooter
toter55932132to_ter
totter65021462totter
touter63821032touter
triter65120592triter
uniter64619142uniter
voicer113910542voicer
voider103611552voider
vomiter1237952vomiter
voter85121052vo_ter
waiter94321252waiter
whiter124316392whiter
writer94416512writer
zoster153715852zoster

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511652.34335233.0
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.51571050.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.