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

101 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
deterrers1011659(None) 
deferrers13115151deferrers
detergers11147181detergers
deterrer9137011deterrer_
deferrer12135592deferrer_
demergers13146402demergers
demurrers1243712demurrers
deserters10129982deserters
deservers13107292deservers
detecters12217752detecters
deterger10147592deterger_
deterges101510092deterge_s
deterred10137802deterre_d
deterrent10128942deterrent
deterrents11126472deterrents
detesters10298302detesters
referrers12125372referrers
alterers82512493alte_rers
caterers102814403cate_rers
debarkers16164553debarkers
deceivers1535723deceivers
decenters122410373decenters
declarers1236423declarers
decreers11277623de_creers
decriers11299733de_criers
defeaters13289103defeaters
defenders1436363defenders
deferrals1343683deferrals
deferred13106363deferre_d
deforcers15265503deforcers
deformers15266533deformers
degenders1236083degenders
dehorners1344743dehorners
dejeuners1742443dejeuners
demerger12127373demerger_
demerges12129503demerge_s
demurrer1144043demurrer_
deplorers1245463deplorers
deporters1277793deporters
derepress1243583derepress
descriers1245693descriers
deserter91211603deserter_
deserver12118383deserver_
deserves12109893deserve_s
desirers939263de_sirers
destriers1038143destriers
detachers1536483detachers
detailers10257253detailers
detainers10269103detainers
detecter11298733detecter_
detectors12278303detectors
detentes92712873detente_s
deterge9118463deterge__
deterged11127923deterge_d
detergent11129573detergent
detergents12116663detergents
determent121312903determent
determents131010313determents
determiners1444643determiners
deterrence1345623deterrence
deterrences1455183deterrences
deterring1138623deterring
deters74724683det___ers
detester9239683detester_
dethroners1443633dethroners
detickers1634423detickers
devourers1344093devourers
dewaterers1442933dewate_rers
dewormers15255193dewormers
ditherers13196683ditherers
diverters13227873diverters
enterers82214153ente_rers
fetterers12267043fetterers
inferrers12226583inferrers
jeerers14328923je_e_rers
letterers9228113letterers
miterers10219683mite_rers
pesterers112510453peste_rers
pewterers14216043pewte_rers
preferrers1542983preferrers
referrer11136053referrer_
reservers12138103reservers
retarders10227573retarders
retempers1345023retempers
retirers84311533ret_irers
retorters938773retorters
returners9376553returners
reverers113113153reve_rers
reversers12298483reversers
reverters122710433reverters
steerers82511353_steerers
stirrers8266943_stirrers
tearers75218233__tearers
termers95414503__termers
terrets72913583__terrets
terriers84210823__terriers
terrors73112213__terrors
utterers8218653utte_rers
veneerers1244523veneerers
waterers112312783wate_rers
westerners1344463westerners

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411016.34323433.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.79526297.4
 
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.