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

61 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
louse56131011louse
lousy84617081lousy
blouse84714722blouse
blousy11459122blousy
bouse75931852bouse
bousy104917842bousy
douse66329722douse
house89131422house
joust125122292joust
loaf76734902lo_af
loafs85616992loafs
lobs66441082lobs_
locus74819992locus_
locust85312342locust
loess55714702loess
logs57343112logs_
loof78141052lo_of
loofs85623782loofs
loos49051122loos_
loose56627682loose
lops66043352lops_
lose45144582lo_se
loss45337962lo_ss
lossy85214642lossy
lost47951492lo_st
lots47652092lots_
lotus55718062lotus_
loud55228042lou_d
lough95118482lough
louie55023512louie
louis57322322louis
louma76213632louma
loup66028432lou_p
loupe75319512loupe
loups75319622loups
lour45430682lou_r
lours55125292lours
loury85716752loury
loused74822912loused
louses66230282louses
lout45952142lou_t
louts56330272louts
lows75843012lows_
lowse87219902lowse
luff104426702l_uff
lush75327692l_ush
lust47442602l_ust
mouse77133002mouse
mousy106716942mousy
nous46136982nous_
oust46747442_oust
pouf95732642pou_f
pouff135215422pouff
poufs105616062poufs
rouse56634702rouse
roust55532062roust
sous46947212sous_
souse56530772souse
touse55430672touse
yous76230652yous_
youse85322232youse

Search took 7 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 Filter178691538002.12684050.3
2DLD Change Limit53800614.56311790.5
3Display Results61610.0461326.1
 (SQL Overall)178691616.73526531.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.