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

71 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
louvers1035910(None) 
louver94110391louver_
louvres10356521louvres
lovers94223431lo_vers
bouviers1375002bouviers
clouters10399792clouters
clovers125114662clo_vers
couters93827282couters
covers114627962co_vers
dousers84817272dousers
flouters11419262flouters
glovers114310882glo_vers
gougers94911762gougers
hoovers134312702hoovers
housers104717812housers
hovers124320252ho_vers
lauders84012892lauders
lavers94526362l_avers
leavers103717782leavers
levers94621322l_evers
livers94927822l_ivers
loaders83413412loaders
loafers10349462loafers
loaners73913622loaners
loaves94813852loave_s
lobbers113713942lobbers
lockers133516922lockers
lodgers95113832lodgers
lofters103912902lofters
loggers94616132loggers
loiters74116612loiters
lollers72713792lollers
loners64225812lo_ners
longers84819542longers
lookers114014072lookers
loopers93914032loopers
looters74419162looters
lopers84424142lo_pers
loppers113014102loppers
losers65123582lo_sers
lotters73921062lotters
loudens8368052loudens
louder74414602louder_
louies64525102louie_s
loungers9449002loungers
loupes84918052loupe_s
lours55125292lou__rs
louses66230282louse_s
louvered1244992louvered
louvre9425682louv_re
louvred11354662louvred
lover85526452lo_ver_
loves85332012lo_ve_s
lowers94624922lo_wers
lugers74617022l_ugers
lurers64217492l_urers
mousers95216442mousers
movers115117192mo_vers
outers64230162_outers
overs85224792_o_vers
plovers123611832plo_vers
pourers93513672pourers
pouters94221862pouters
rousers75220132rousers
routers74822852routers
rovers95423522ro_vers
solvers104414252solvers
souters74422582souters
tourers73512732tourers
touters74018332touters
wolvers13349312wolvers

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 Limit107671713.72028943.8
3Display Results71710.0302366.7
 (SQL Overall)178691713.89045936.0
 
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.