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

120 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
loaner6441650(None) 
leaner64022191leaner
loader74316311loader
loafer93610941loafer
loaned73816291loaned
loaners73913621loaners
loner55431041lo_ner
moaner84415111moaner
bloater94013422bloater
boater84622092boater
boner75133082bo_ner
caner75334772_caner
cleaner93712302cleaner
cloner84418092clo_ner
coaler84121712coaler
coater84329572coater
coaxer153912792coaxer
coiner84323782coiner
conner84423962conner
corner84625622corner
downer104414922downer
eloiner7149182eloiner
floater104413352floater
foamer114714312foamer
gleaner8379772gleaner
gloater83711012gloater
goner66025162go_ner
groaner82510132groaner
hoaxer16348562hoaxer
honer85332092ho_ner
inaner62213542inaner
joiner134114132joiner
laager74312782laager
lacer75833752l_acer
lader65633722l_ader
lager65132862l_ager
laker95432872l_aker
lamer75233702l_amer
lancer84319972l_ancer
lander74028482l_ander
lane45153332l_ane_
lanes54946792l_anes
lanker104123002l_anker
lanner64920602lanner
laser54633322l_aser
later54843922l_ater
laver85031792l_aver
laxer125420332l_axer
layer84626472l_ayer
leader74824652leader
leaker104620072leaker
leaned73422542leaned
leaners73718172leaners
leaper88118942leaper
learner7319382learner
leaser65322672leaser
leaver94321512leaver
liane54720662liane_
lianes63819322lianes
limner84112872limner
liner55938922l_iner
loaded84616872loaded
loaders83413432loaders
loafed104011152loafed
loafers10349462loafers
loamed94414612loamed
loamier9349162loamier
loan47436452loan__
loans56026462loan_s
loather103711002loather
loaves94813852loaves
lobber104016602lobber
locater93113602locater
locker124019422locker
lodger86517682lodger
lofter94614722lofter
logger86420002logger
logier75015732logier
loiter64619172loiter
loller63315282loller
lone45849132lo_ne_
loners64225812lo_ners
longer75823202longer
looker104816952looker
looney94712412looney
loonier73312682loonier
looper83817112looper
looser65219942looser
looter64222322looter
loper75129232lo_per
lopper103717202lopper
loriner7511892loriner
loser54728672lo_ser
lotter64025602lotter
louder74414602louder
lounger84610212lounger
louver94110392louver
lover85526452lo_ver
lower85830412lo_wer
loyaler1035082loyaler
meaner84617842meaner
moaned94514172moaned
moaners92813552moaners
mooner85317832mooner
oater55433732_oater
owner84613312_owner
planer84122652planer
roamer84715162roamer
roarer63914332roarer
saner54334322_saner
soaker105717532soaker
soaper84517872soaper
soarer64522242soarer
sooner64220462sooner
sorner64720392sorner
toner55336242to_ner
tonner64819202tonner
weaner93816772weaner
wonner95114442wonner
zoner144520342zo_ner

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.1101624463.6
2DLD Change Limit825511202.51632810.4
3Display Results1201200.0462608.7
 (SQL Overall)1786911202.67266875.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.