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

99 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
lousy8461708(None) 
blousy11459121blousy
bousy104917841bousy
lossy85214641lossy
loury85716751loury
louse56131011louse
mousy106716941mousy
blouse84714722blouse
blowsy14579452blowsy
bossy105515972bossy
bouse75931852bouse
busy94727172_busy
cloudy12517802cloudy
cosy97232702co_sy
donsy96414682donsy
douse66329722douse
floosy12368152floosy
flossy12517702flossy
floury12449572floury
glossy10549002glossy
goosy96018882goosy
gorsy95915782gorsy
gouty95217362gouty
horsy116318392horsy
house89131422house
joust125122292joust
loamy105913342loamy
lobby125113912lobby
lobs66441082lobs_
locus74819992locus_
locust85312342locust
loess55714702loess
lofty115813302lofty
loggy105714192loggy
logs57343112logs_
logy87025782lo_gy
lolly85120662lolly
looby108115622looby
looey84822912looey
loony86918962loony
loopy105316642loopy
loos49051122loos_
loose56627682loose
loppy125911662loppy
lops66043352lops_
lorry86315662lorry
lory75931712lo_ry
lose45144582lo_se
loss45337962lo_ss
lost47951492lo_st
lots47652092lots_
lotus55718062lotus_
loud55228042lou_d
loudly1037782loudly
lough95118482lough
louie55023512louie
louis57322322louis
louma76213632louma
loungy10476832loungy
loup66028432lou_p
loupe75319512loupe
loups75319622loups
lour45430682lou_r
lours55125292lours
loused74822912loused
louses66230282louses
lousily1038332lousily
lout45952142lou_t
louts56330272louts
lowly114113332lowly
lows75843012lows_
lowse87219902lowse
luny77324132l_uny
lush75327692l_ush
lust47442602l_ust
lusty85417572l_usty
mossy105217062mossy
mouse77133002mouse
mousey115216192mousey
noisy86813362noisy
nosy76322892no_sy
nous46136982nous_
oust46747442_oust
poesy105014062poesy
popsy125713402popsy
posy96028422po_sy
potsy105815612potsy
pouty107018812pouty
rosy76024872ro_sy
roupy106112712roupy
rouse56634702rouse
roust55532062roust
sonsy86416372sonsy
soupy106115402soupy
sous46947212sous_
souse56530772souse
touse55430672touse
yous76230652yous_
youse85322232youse

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 Filter178691538000.1101624463.6
2DLD Change Limit53800992.98318035.5
3Display Results99990.0631571.4
 (SQL Overall)178691993.15656619.5
 
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.