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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
detergers1114718(None) 
demergers13146401demergers
deterger10147591deterger_
deterges101510091deterge_s
deterrers10116591deterrers
deferrers13115152deferrers
demerger12127372demerger_
demerges12129502demerge_s
deserters10129982deserters
deservers13107292deservers
detecters12217752detecters
deterge9118462deterge__
deterged11127922deterge_d
detergent11129572detergent
detergents12116662detergents
deterrer9137012deterrer_
detesters10298302detesters
alterers82512503alter_ers
caterers102814413cater_ers
debarkers16164553debarkers
debuggers1442713debuggers
deceivers1535723deceivers
decenters122410373decenters
decreers11277623de_creers
decriers11299733de_criers
defeaters13289103defeaters
defenders1436363defenders
deferrer12135593deferrer_
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
degenders1236083degenders
dehorners1344743dehorners
dejeuners1742443dejeuners
demerge11168023demerge__
demerged13157603demerge_d
demergered1543173demergered
demurrers1243713demurrers
deporters1277793deporters
derangers1136703derangers
deringers1137183deringers
descriers1245693descriers
deserter91211603deserter_
deserver12118383deserver_
deserves12109893deserve_s
desirers939263desir_ers
destriers1038143destriers
detachers1536483detachers
detailers10257253detailers
detainers10269103detainers
detecter11298733detecter_
detectors12278303detectors
detentes92712873detente_s
detergency1754183detergency
deterging1237853deterging
determent121312903determent
determents131010313determents
determiners1444643determiners
deterred10137803deterre_d
deterrent10128943deterrent
deterrents11126473deterrents
deters74724683det___ers
detester9239683detester_
dethroners1443633dethroners
detickers1634423detickers
dewaterers1442933dewater_ers
dewormers15255193dewormers
ditherers13196683dither_ers
diverges13258313diverge_s
diverters13227873diverters
dredgers11256093d_redgers
emerges101310883_emerge_s
enterers82214153enter_ers
fetterers12267043fetter_ers
integers937783inte_gers
jeerers14328923je_er_ers
letterers9228113letter_ers
mergers103813423__mergers
meterages1248183meterage_s
miterers10219683miter_ers
pesterers112510463pester_ers
pewterers14216043pewter_ers
referrers12125373referrers
remerges111110203remerge_s
renegers9248793rene_gers
reservers12138103reservers
retarders10227573retarders
retargets1045303retargets
retempers1345023retempers
retirers84311533retir_ers
retorters938773retorters
returners9376553returners
revengers1336413revengers
reverers113113153rever_ers
reversers12298483reversers
reverters122710433reverters
sergers83815633__sergers
steerers82511353steer_ers
termers95414503__termers
utterers8218653utter_ers
vergers114412633__vergers
waterers112312793water_ers
westerners1344473westerners

Search took 8 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.406440125.6
2DLD Change Limit1486411036.79621871.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.24824653.8
 
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.