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

112 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
deflators1334815(None) 
deflaters13298701deflaters
deflator12328341deflator_
delators92314831de_lators
defalcators1742862defalcators
defeaters13289102defeaters
defecators1656252defecators
defectors15237882defectors
deflater123211602deflater_
deflates123013942deflat_es
deflations1439712deflations
deflectors1654772deflectors
defoliators1543722defoliators
delator83015032de_lator_
depilators1347332depilators
desolators1146282desolators
deviators1358542deviators
dilators93213202d_ilators
fellators1247152fellators
inflators1257712inflators
relators83316132re_lators
ablators1069883_ablators
adulators1048063adulators
aerators8315613ae_rators
beclamors1574223beclamors
beglamors1473373beglamors
belabors1236403be_labors
chelators1448173chelators
collators11410343collators
deaerators11107713deaerators
dealates92716683dealat_es
dealations11311373dealations
debaters113511923de_baters
debtors1038533de__btors
decimators1547503decimators
declarers1236423declarers
decorators1347873decorators
dedicators1447743dedicators
defacers14237993def_acers
defalcator1643173defalcator_
defamatory1943493defamatory
defamers14258523def_amers
defats105114553def_at__s
defeater122611663defeater_
defeats113511233defeat__s
defeature1344343defeature
defeatures1444013defeatures
defecator1546383defecator_
defector14277953defector_
deflate113613943deflat__e
deflated133412303deflat_ed
deflating142610713deflating
deflation13310653deflation
deflector1555063deflector_
deflowers16145643deflowers
defoamers15285253defoamers
defoliator1444183defoliator_
defrayers1644173defrayers
delates83526283de_lat_es
delations102616593de_lations
delayers12268663de_layers
delegators1245633delegators
demeanors1243743demeanors
depictors1465943depictors
depilator1247653depilator_
depilatory1645743depilatory
depleters12327543depleters
depurators1346483depurators
desalters1037673desalters
desolaters1146043desolaters
desolator1046673desolator_
detectors12278303detectors
detonators1145853detonators
detractors13147293detractors
deviator1248323deviator_
deviatory1666453deviatory
dewaters122910723de_waters
dictators1247363dictators
dilaters92513063d_ilaters
dilator82712793d_ilator_
dilatory12279283d_ilatory
dilutors9306653d_ilutors
donators9310403d_onators
educators1246993educators
elaters74420193_e_laters
emulators1148183emulators
epilators1149433epilators
equators1737473_equators
fellator1176723fellator_
flavors1337293__flavors
gelatos83111523ge_lato_s
idolators1046283idolators
inflaters1247543inflaters
inflator1158033inflator_
isolators947513isolators
legators92811033le_gators
levators11249283le_vators
mediators1248923mediators
negators92411173ne_gators
peculators1486983peculators
realtors82811683real_tors
reflates113115663reflat_es
reflations13311233reflations
reflectors1545503reflectors
refractors15156273refractors
regulators1146503regulators
relaters83218153re_laters
relator74016373re_lator_
revelators13116423revelators
senators8312953se_nators
testators947333testators
violators1246583violators

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.436409841.7
2DLD Change Limit1486411127.53019739.8
3Display Results1121120.0631777.8
 (SQL Overall)1786911128.02922255.7
 
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.