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 “loaners” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
loaners7391362(None) 
leaners73718171leaners
loaders83413431loaders
loafers10349461loafers
loaner64416501loaner_
loners64225811lo_ners
moaners92813551moaners
bloaters103311022bloaters
boaters93419242boaters
boners84825432bo_ners
caners84629202_caners
cleaners103610542cleaners
cloners94514822clo_ners
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
coiners93620752coiners
conners94023112conners
corners94723312corners
downers113912772downers
eloiners8128152eloiners
floaters112711512floaters
foamers123812102foamers
gleaners9348072gleaners
gloaters9288862gloaters
goners74420172go_ners
groaners9248502groaners
hoaxers17327132hoaxers
honers94324972ho_ners
joiners144211572joiners
laagers83411252laagers
lacers85225252l_acers
laders74927762l_aders
lagers74826142l_agers
lakers105225152l_akers
lancers93616642l_ancers
landers84026212l_anders
lanes54946792l_ane_s
lanners73618332lanners
lasers64925702l_asers
lavers94526362l_avers
layers93921182l_ayers
leaders83819602leaders
leakers113415422leakers
leaner64022192leaner_
leapers93716662leapers
learners8398152learners
leasers74717842leasers
leavers103717782leavers
lianes63819322liane_s
limners93311562limners
liners65428852l_iners
loader74316312loader_
loafer93610942loafer_
loaned73816292loane_d
loans56026462loan__s
loathers113310442loathers
loaves94813852loave_s
lobbers113713942lobbers
locaters102710072locaters
lockers133516922lockers
lodgers95113832lodgers
lofters103912902lofters
loggers94616132loggers
loiters74116612loiters
lollers72713792lollers
loner55431042lo_ner_
longers84819542longers
lookers114014072lookers
looneys10487012looneys
loopers93914032loopers
looters74419162looters
lopers84424142lo_pers
loppers113014102loppers
loriners839962loriners
losers65123582lo_sers
lotters73921062lotters
loungers9449002loungers
louvers10359102louvers
lovers94223432lo_vers
lowers94624922lo_wers
lowness1037812lowness
meaners94415242meaners
moaner84415112moaner_
mooners94015342mooners
oaters65029792_oaters
owners94210702_owners
planers94517942planers
roamers93713462roamers
roarers73812742roarers
soakers114114952soakers
soapers93715922soapers
soarers74118092soarers
sooners73916642sooners
sorners73416872sorners
toners64128002to_ners
tonners73816402tonners
weaners104613832weaners
wonners104312812wonners
zoners155115992zo_ners

Search took 8 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711007.53314293.2
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.70323197.6
 
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.