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

122 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
deflator1232834(None) 
deflater123211601deflater
deflators13348151deflators
delator83015031de_lator
defalcator1643172defalcator
defeater122611662defeater
defecator1546382defecator
defector14277952defector
deflate113613942deflat_e
deflated133412302deflated
deflaters13298702deflaters
deflates123013942deflates
deflation13310652deflation
deflector1555062deflector
defoliator1444182defoliator
delators92314832de_lators
depilator1247652depilator
desolator1046672desolator
deviator1248312deviator
dilator82712792d_ilator
fellator1176712fellator
inflator1158032inflator
relator74016372re_lator
ablator939853_ablator
adulator948593adulator
aerator7314843ae_rator
beclamor1484303beclamor
beglamor1383193beglamor
belabor1136293be_labor
chelator1347913chelator
collator10310373collator
deaerator10128113deaerator
dealate83617843dealat_e
dealated103213603dealated
dealates92716683dealates
dealation10313003dealation
debater104114693de_bater
debtor938333de__btor
decimator1447733decimator
declarer1148063declarer
decorator1248573decorator
dedicator1348253dedicator
defacer132810363def_acer
defalcators1742863defalcators
defamatory1943493defamatory
defamer132710323def_amer
defat95426693def_at__
defats105114553def_at_s
defeat103817163defeat__
defeated132812163defeated
defeaters13289103defeaters
defeats113511233defeat_s
defeature1344343defeature
defecators1656253defecators
defectors15237883defectors
deflating142610713deflating
deflations1439713deflations
deflectors1654773deflectors
deflower15126073deflower
defoamer14276213defoamer
defoliators1543723defoliators
defrayer1534933defrayer
defter104215923def__ter
delate73827753de_lat_e
delated93722873de_lated
delates83526283de_lates
delation92318083de_lation
delayer113010533de_layer
delegator1146243delegator
demeanor1143833demeanor
depictor1355513depictor
depilators1347333depilators
depilatory1645743depilatory
depleter11298863depleter
depurator1247023depurator
desalter938363desalter
desolater1038383desolater
desolators1146283desolators
detector11278323detector
detonator1045983detonator
detractor12147213detractor
deviators1358533deviators
deviatory1666443deviatory
dewater112912423de_water
dictator1147263dictator
dilater83515653d_ilater
dilators93213203d_ilators
dilatory12279283d_ilatory
dilutor8256013d_ilutor
donator8310263d_onator
educator1147153educator
elater64724203_e_later
emulator1048743emulator
epilator1049243epilator
equator1637483_equator
fellators1247143fellators
flavor1236663__flavor
gelato73812963ge_lato_
gelatos83111523ge_latos
idolator946243idolator
inflater1149893inflater
inflators1257713inflators
isolator847533isolator
legator83011133le_gator
levator10298963le_vator
mediator1139043mediator
negator83010673ne_gator
peculator1387863peculator
realtor73611353real_tor
reflate103516263reflat_e
reflated123514293reflated
reflates113115663reflates
reflation12412333reflation
reflector1445733reflector
refractor14156323refractor
regulator1046973regulator
relater73723143re_later
relators83316133re_lators
revelator1286533revelator
senator7313073se_nator
testator847373testator
violator1146283violator

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621227.58019282.6
3Display Results1221220.0462652.2
 (SQL Overall)1786911228.02922255.7
 
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.