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

257 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
deflating14261071(None) 
defeating142311971defeating
delating103119601de_lating
reflating132514711reflating
debating123213732de_bating
declaring1339572declaring
declawing1636212declawing
defacing15238682def_acing
defalcating1844342defalcating
defaming15238462def_aming
defatting1436102defatting
defecating17237782defecating
defecting162510222defecting
defilading1643642defilading
deflation13310652deflation
deflations1439712deflations
defleaing1444742defleaing
deflecting1736502deflecting
defoaming1645652defoaming
defoliating1645822defoliating
defraying1735852defraying
deglazing2135132deglazing
delaying133210972de_laying
deleting103314422de_leting
depilating1439192depilating
deplaning1338052deplaning
depleting1378192depleting
derating103222282de_rating
desalting1138842desalting
desolating1239462desolating
deviating14311092deviating
dilating102714912d_ilating
elating83423082_e_lating
fellating1339252fellating
gelating103015732ge_lating
inflating13310442inflating
refloating14198322refloating
relating92725442re_lating
replating122217402replating
reslating102516992reslating
ablating11312003_ablating
acylating1547573acylating
adulating1178723adulating
aerating92821003ae_rating
beating104326873be__ating
befalling15226503befalling
befitting15236623befitting
beflagging1842823beflagging
befleaing1544023befleaing
belaying143110603be_laying
belting104119133be_l_ting
berating113220763be_rating
cellaring1238533cellaring
chelating1549363chelating
collating12312783collating
conflating16410003conflating
dating85326483d___ating
deaerating12311563deaerating
dealation10313003dealation
dealations11311373dealations
dealing94323233de__aling
deaning94020473de__aning
deaving123814753de__aving
debasing12238063de_basing
debeaking1735923debeaking
debiting122511203de_biting
debuting12268633de_buting
decanting132510633decanting
decaying15239453de_caying
deceasing1338403deceasing
decimating1648763decimating
declaiming1644783declaiming
declassing1445123declassing
declining13129353declining
decocting1538123decocting
decollating1545973decollating
decorating14312073decorating
dedicating1539143dedicating
deducting1436843deducting
deejaying2142753deejaying
defang1137753def_a__ng
defanging1535333defanging
defaulting1543393defaulting
defeatism1544413defeatism
defeatist1356603defeatist
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
defiling132812463def_iling
defining133711803def_ining
deflagrating1852663deflagrating
deflate113613943deflat__e
deflated133412303deflat_ed
deflater123211603deflat_er
deflaters13298703deflaters
deflates123013943deflat_es
deflator12328343deflat_or
deflators13348153deflators
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defragging1742823defragging
defrauding1642923defrauding
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227943def_using
defuzing22195253def_uzing
defying15328823def__ying
degrading13137373degrading
degusting1236163degusting
dehorting1447213dehorting
dejecting20217793dejecting
delaine8314793de_la_ine
delation92318083de_lation
delations102616593de_lations
deleading1237773deleading
deleaving1436263deleaving
delegating1337673delegating
deleing93313953de_l_eing
deliming12310373de_liming
delisting112710503delisting
deluding1137683de_luding
deluging1137123de_luging
delving123711573de_l_ving
demasting1338453demasting
demeaning1337243demeaning
dementing13311043dementing
demitting13239073demitting
demoting12311423de_moting
denoting10311753de_noting
denting94422183de__nting
denudating1345263denudating
departing1349513departing
depicting1537813depicting
deploring1337853deploring
deploying1636153deploying
depluming1544713depluming
deporting1369593deporting
depraving1635973depraving
depurating1438643depurating
deputing12238793de_puting
deratting1139513deratting
derogating1348633derogating
descanting1446923descanting
deserting11713143deserting
desisting112810383desisting
despiting13179323despiting
detecting13259983detecting
detesting112610323detesting
detonating1248823detonating
detracting1438713detracting
devaluating1645053devaluating
devaluing1434833devaluing
devesting14249903devesting
devoting1338823de_voting
dewaxing20215293de_waxing
dictating1338883dictating
diluting10248983d_iluting
disrating11714553disrating
doating93816863d__oating
donating10311803d_onating
eating75134403_e__ating
educating1337933educating
effacing1744463_effacing
eluting84115293_e_luting
emulating1239873emulating
enflaming1545633enflaming
enlacing1148773_enlacing
epilating12310973epilating
equating18310113_equating
estating92614993_estating
exalting1638033_exalting
fating105328673__f_ating
felting113515213fe_l_ting
flaking154114493__flaking
flaming134216443__flaming
flaring114116803__flaring
flatling123410013__flatling
flatting123511253__flatting
flawing143812563__flawing
flaying143914463__flaying
fliting113514613__fliting
floating123111883__floating
fluting113815093__fluting
flyting14378553__flyting
gelatin83514733ge_latin_
gelatine93213313ge_latine
gelatins93414093ge_latins
gemmating1576443gemmating
gestating11229983gestating
heating114024323he__ating
hefting144510913hef__ting
ideating10311703ide__ating
inflaming1546263inflaming
isolating1039743isolating
leafleting1442893leafleting
legating102313113le_gating
mediating13311203mediating
melting103317753me_l_ting
negating102012833ne_gating
ovulating1336953ovulating
oxalating1745803oxalating
peculating1549163peculating
pelleting1237953pelleting
pelting102917273pe_l_ting
plating103823073__plating
rebating112418343re_bating
recoating121317463recoating
recrating121318793recrating
redating102620173re_dating
redefeating1645333redefeating
refacing142512813ref_acing
refalling132010423refalling
refecting152413353refecting
refitting132811123refitting
reflagging1643483reflagging
reflation12412333reflation
reflations13311233reflations
reflecting1638823reflecting
reflexing2035933reflexing
reflowing1636523reflowing
refluxing2034583refluxing
reflying15268173refl_ying
refracting1638733refracting
reframing1538623reframing
refuting121911903ref_uting
regelating1239953regelating
reglazing2046553reglazing
regrating111316213regrating
regulating12310063regulating
reheating132314913reheating
reinflating1545993reinflating
relacing112516043re_lacing
relaxing162612633re_laxing
relaying122515153re_laying
remating112322423re_mating
repeating122618983repeating
replacing142210163replacing
replanting1338523replanting
replaying15259603replaying
reseating102421533reseating
restating102319413restating
seating84130683se__ating
sedating103014113se_dating
sensating1039253sensating
seriating10916403seriating
serrating10513213serrating
slating83724653__slating
solating9315593_solating
sublating12310983sublating
sufflating1744843sufflating
sulfating1338063sulfating
ululating1036643ululating
violating1337443violating
welting113615313we_l_ting

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.423422437.4
2DLD Change Limit1486412577.34320242.5
3Display Results2572570.1102336.4
 (SQL Overall)1786912577.87622688.0
 
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.