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
loaders83413411loaders
loafers10349461loafers
loaner64416501loaner_
loners64225801lo_ners
moaners92813551moaners
bloaters103311012bloaters
boaters93419232boaters
boners84825432bo_ners
caners84629192_caners
cleaners103610532cleaners
cloners94514822clo_ners
coalers94419332coalers
coaters93525772coaters
coaxers164311062coaxers
coiners93620752coiners
conners94023112conners
corners94723312corners
downers113912772downers
eloiners8128152eloiners
floaters112711502floaters
foamers123812102foamers
gleaners9348072gleaners
gloaters9288852gloaters
goners74420162go_ners
groaners9248492groaners
hoaxers17327132hoaxers
honers94324972ho_ners
joiners144211572joiners
laagers83411252laagers
lacers85225252l_acers
laders74927762l_aders
lagers74826142l_agers
lakers105225152l_akers
lancers93616642l_ancers
landers84026212l_anders
lanes54946792l_ane_s
lanners73618322lanners
lasers64925702l_asers
lavers94526362l_avers
layers93921182l_ayers
leaders83819602leaders
leakers113415422leakers
leaner64022192leaner_
leapers93716662leapers
learners8398152learners
leasers74717842leasers
leavers103717782leavers
lianes63819322liane_s
limners93311552limners
liners65428842l_iners
loader74316302loader_
loafer93610942loafer_
loaned73816292loane_d
loans56026462loan__s
loathers113310432loathers
loaves94813852loave_s
lobbers113713932lobbers
locaters102710062locaters
lockers133516922lockers
lodgers95113832lodgers
lofters103912902lofters
loggers94616132loggers
loiters74116612loiters
lollers72713792lollers
loner55431032lo_ner_
longers84819532longers
lookers114014072lookers
looneys10487012looneys
loopers93914032loopers
looters74419162looters
lopers84424142lo_pers
loppers113014102loppers
loriners839962loriners
losers65123582lo_sers
lotters73921062lotters
loungers9449002loungers
louvers10359102louvers
lovers94223432lo_vers
lowers94624922lo_wers
lowness1037812lowness
meaners94415242meaners
moaner84415112moaner_
mooners94015342mooners
oaters65029782_oaters
owners94210702_owners
planers94517942planers
roamers93713452roamers
roarers73812732roarers
soakers114114952soakers
soapers93715922soapers
soarers74118092soarers
sooners73916642sooners
sorners73416862sorners
toners64128002to_ners
tonners73816402tonners
weaners104613832weaners
wonners104312812wonners
zoners155115992zo_ners

Search took 4 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 Limit1076711003.75328689.3
3Display Results1001000.0462173.9
 (SQL Overall)1786911003.93945364.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.