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

148 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
louis5732232(None) 
loris55329151loris
louie55023511louie
louies64525101louies
loups75319621loups
lours55125291lours
louts56330271louts
bouts75131312bouts
clouds94612352clouds
clours85215092clours
clouts87017202clouts
coulis84018762coulis
coups95522472coups
doums85417642doums
etuis54013132etuis
flours94414052flours
flouts94315272flouts
fouls87221432fouls
fours85521492fours
glouts74414712glouts
gouts64826172gouts
houris94514582houris
hours85422392hours
jouks165612342jouks
kois85129402ko_is
kojis16468442kojis
koumis1237622koumis
lapis76223152lapis
laris54737462laris
lauds65618482lauds
leis45739602l_eis
lenis56326862lenis
leuds66214812leuds
levis85818552levis
lewis85315842lewis
lexis125916032lexis
lis37162272l__is
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
loci66126282loci_
locks115126922locks
locos75822602locos
locums10478302locums
locus74819992locus
lodes66436912lodes
loess55714702loess
lofts85518362lofts
loges66534202loges
logia68116602logia
logic88217832logic
logics95711122logics
login66025002login
logins77820642logins
logos67225332logos
logs57343112lo_gs
loid55531492lo_id
loids66220702loids
loin46838722lo_in
loins56728422loins
lolls512121732lolls
longs65527062longs
loofs85623782loofs
looie55624242looie
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loots55431422loots
lopes76437342lopes
lops66043352lo_ps
lords64923502lords
lores55045402lores
lories64933042lories
loses56742012loses
loss45337962lo_ss
lotas55926302lotas
loti46431842loti_
lotic76420672lotic
lotos54724632lotos
lots47652092lo_ts
lotus55718062lotus
loud55228042lou_d
loudish1137982loudish
lough95118482lough
loughs105014772loughs
louma76213632louma
loumas84812332loumas
loup66028432lou_p
loupe75319512loupe
loupes84918052loupes
lour45430682lou_r
loury85716752loury
louse56131012louse
louses66230282louses
lousy84617082lousy
lout45952142lou_t
loutish1039962loutish
loves85332012loves
lowes85732462lowes
lowish12310532lowish
lows75843012lo_ws
loxes125227472loxes
lues45943552l_ues
lugs55233522l_ugs
lums65734242l_ums
luvs75818502l_uvs
lweis8458692lweis
lysis84511462lysis
moues75732842moues
noris54928272noris
nouns56717312nouns
nous46136982nou_s
obis66226842_obis
ouds56430102_ouds
ours47237562_ours
outs45746962_outs
pois66539042po_is
polis74731162polis
poufs105616062poufs
pours74623182pours
pouts75530322pouts
rotis56327062rotis
roues56039352roues
roups75118902roups
routs57133412routs
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
topis76025832topis
tours55325892tours
touts54830392touts
tuis44829642_tuis
yogis95617742yogis
yonis85020822yonis
yours85217882yours
yous76230652you_s
zoris145320012zoris
zouks184410502zouks

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 Filter178691538000.326548131.9
2DLD Change Limit538001481.62633087.3
3Display Results1481480.0463217.4
 (SQL Overall)1786911481.99889434.9
 
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.