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 “delousers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
delousers104466(None) 
delouser936361delouser_
delouses9310011delouse_s
defusers12487362de_fusers
delouse839832delouse__
deloused1036982delouse_d
deluders10156432del_uders
delusters1035982del_usters
deposers11359242depo_sers
devourers1344092devourers
dousers84817272d__ousers
arousers84810983_arousers
befoulers1443123befoulers
blouses94014463_blouse_s
carousers1156743carousers
chousers134610203_chousers
closers94415323_clo_sers
clouters10399803_clouters
colourers1136473colourers
debasers11377903de_basers
deboners11268113debo_ners
decoders122810413deco_ders
decouplers1573083decouplers
decoyers14287713deco_yers
deflowers16145643deflo_wers
defoamers15285253defoamers
defocuses15134493defocuse_s
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
defuser115110503de_fuser_
defuses114814593de_fuse_s
degassers11354833degassers
degaussers1241663degaussers
dehorners1344743dehorners
dejeuners1742443dejeuners
delayers12268663del_ayers
delivers123310753del_ivers
delousing1136303delousing
deluder9168333del_uder_
deludes91810643del_ude_s
deluges9169263del_uge_s
delusory1273003del_usory
deluster936903del_uster_
delvers113411993del__vers
demoses103815833demo_se_s
denouncers1343403denouncers
denuders10165873de_nuders
deplorers1245463deplo_rers
deployers1545063deplo_yers
deporters1277793deporters
deposer104011843depo_ser_
deposes103117213depo_se_s
despisers1245153despisers
detours858043detou__rs
devisers12339863de_visers
devourer1235063devourer_
devours1166643devou__rs
devouter1235513devouter_
dewormers15255193dewormers
diffusers1642783diffusers
diluters9288113dil_uters
dolours8438823dolou__rs
dorsers83516303d__orsers
dosers75723633d__o_sers
dossers84516233d__ossers
douser75621633d__ouser_
douses74928933d__ouse_s
dowsers115013533d__owsers
eloiners8128153_eloiners
elopers95112943_elo_pers
eluders8409903_el_uders
espousers1143383espousers
excusers1734443_excusers
flossers11307863_flossers
flouters11419273_flouters
glossers9319053_glossers
grousers93810733_grousers
housers104717823__housers
losers65123583__lo_sers
louses66230283__louse_s
louvers10359103__louvers
mousers95216443__mousers
peloruses1145873peloruse_s
perusers10328803pe_rusers
refusers11499273re_fusers
rehouses11312113rehouse_s
relapsers1164123relapsers
releasers937323releasers
reloaders1036423reloaders
reposers102911603repo_sers
rousers75220143__rousers
trousers83910633_trousers
velours10278083velou__rs
veloutes1136153veloute_s

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit148641957.53319732.0
3Display Results95950.0462065.2
 (SQL Overall)178691957.99922339.2
 
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.