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

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

215 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
redefecting184437(None) 
redefeating1645331redefeating
defecting162510222__defecting
redirecting1545612redirecting
reejecting2045812re_ejecting
reelecting1338782re_electing
reerecting1339972re_erecting
refecting152413352r__efecting
reinfecting1745152reinfecting
reselecting1446022reselecting
defeating142311973__defeating
defecating17237783__defecating
deflecting1736503__deflecting
dejecting20217793__dejecting
deselecting1544473deselecting
detecting13259983__detecting
effecting1845583_e_ffecting
perfecting1847513pe_rfecting
prededucting1952553prededucting
preelecting1646473pre_electing
preerecting1646143pre_erecting
preselecting1744293preselecting
recementing1645223recementing
redacting13612303red__acting
rededicating1744333rededicating
redeeming1337363rede_e_ming
redefect1446053redefect___
redefected1743853redefect_ed
redefects1543793redefect__s
redefining1545423redef_ining
redefying1736093redef__ying
redigesting1444573redigesting
reenacting1357353re_enacting
reexecuting2142543re_executing
reflecting1638823re_flecting
reinjecting2144453reinjecting
rejecting192211153r__ejecting
remeeting12311433reme_e_ting
reobjecting2343033reobjecting
rerepeating1447183rerepeating
resecting122816483r__esecting
respecting1549883re_specting
advecting1645114_ad_vecting
affecting1845234__affecting
bedeafening1852104bedeafe_ning
bedecking1934284bed__ecking
beneficing1843824benefic_ing
benefiting1644314benef_iting
benefitting1752854benefitting
beseeching1843364bese_eching
codirecting1743644codirecting
coerecting15218784_coerecting
coinfecting1944574coinfecting
confecting18310554_confecting
decocting1538124__decocting
deducting1436844__deducting
defacing15238684__defac_ing
defatting1436104__defatting
defection151610644__defection
defections161510204__defections
defective1848004__defective
defencing16226694__defencing
defending15298354__defending
defensing14217004__defensing
deferring1436144__deferring
deflating142610714__deflating
deleting103314424__dele_ting
dementing13311044__dementing
depicting1537814__depicting
deserting11713144__deserting
detesting112610324__detesting
devesting14249904__devesting
directing1338824__directing
ejecting18268164___ejecting
electing112113784___electing
erecting112415064___erecting
expecting2146694_e_xpecting
exsecting1935934_e_xsecting
eyeletting1442874_eyeletting
federating1548854fede_rating
genuflecting1961254genuflecting
infecting15109674__infecting
medevacing1942864medevac_ing
medevacking2451914medevacking
neglecting1444544ne_glecting
praelecting1644534praelecting
predeceasing18103064predeceasing
predefining1844164predef_ining
predicting1649874pred__icting
predigesting1753684predigesting
preenacting16125374pre_enacting
prelecting15310164_prelecting
reaccenting1665014reaccenting
reaccepting1863894reaccepting
reacting113317894r__e_acting
readdicting1643814readdicting
rearresting1245964rearresting
reasserting1246154reasserting
receipting1546754rece_ipting
rechecking2244464re_checking
recollecting1764084recollecting
reconnecting1745354reconnecting
recreating131214584re_creating
redating102620174red___ating
redbaiting1446264red_baiting
reddening1237434red_de_ning
redeciding1544704rede_ciding
redecorating16115054redecorating
redefeat1246314redefeat___
redefeated1544884redefeat_ed
redefeats1344204redefeat__s
redefine1238974redef___ine
redemanding1643484redemanding
redenying1437784red__enying
redeploying1842704redeploying
redepositing1652824redepositing
redescending1752574redescending
redesigning1443654redesigning
redetermine14103694redetermine
redeveloping1952214redeveloping
redictating1546804redictating
redirection1446054redirection
redirections1546174redirections
redocking17126784red__ocking
redrafting1545964red_rafting
redreaming1446444red_reaming
redressing1247824red_ressing
redshirting1643264redshirting
reducing12310204red__uc_ing
redyeing1336174red_ye__ing
reediting11310954re_e_diting
reeducating1545164reeducating
reefing114016864re_ef___ing
reelection12198634re_election
reelections13167944re_elections
reelevating1544964re_elevating
reemerging1474584re_emerging
reemitting1346634re_emitting
reesting93118274r__e_esting
refacing142512814r__efac_ing
refection141512284r__efection
refections151811644r__efections
refective1749114r__efective
refeeding14247934r__efeeding
refeeling13229314r__efeeling
refelling132211314r__efelling
refencing15188854r__efencing
refereeing1444674refere_eing
referencing1744494referencing
referring1338034r__eferring
refitting132811124r__efitting
reflating132514714r__eflating
reforesting1546194reforesting
refracting1638734re_fracting
refuting121911904r__ef_uting
regelating1239954rege_lating
regenerating1446334regenerating
regimenting1544664regimenting
regreeting1237344re_greeting
regretting1237784re_gretting
reheating132314914r__eheating
reheeling13218264rehe_e_ling
reindicting1545074reindicting
reinducting1544384reinducting
reinfection1645444reinfection
reinfections1745324reinfections
reinflating1545994reinflating
reinserting1256904reinserting
reinspecting1763204reinspecting
reinventing1545254reinventing
reinvesting1545324reinvesting
relegating1239484rele_gating
relenting102716774r__elenting
reletting102713944r__eletting
relucting1239774r__elucting
remediating1547134remediating
remelting12311704r__emelting
renesting102514704r__enesting
reoffering1744094reoffe_ring
reorienting1246354reorienting
repeating122618984r__epeating
repenting122316554r__epenting
representing1555134representing
requesting2046314re_questing
rereleasing1243984rereleasing
rerenting102617664r__erenting
researching1743424researching
reseating102421534r__eseating
reseeding112410494rese_e_ding
reseeing92412624rese_e__ing
reseeking14208494rese_e_king
resenting102619294r__esenting
resetting102816294r__esetting
resifting133512094resif__ting
resmelting1337264re_smelting
restricting1449304restricting
resubjecting2451994resubjecting
resurrecting1553124resurrecting
reteaching1636024rete_aching
retesting102614604r__etesting
retracting13311934re_tracting
retreating111414774re_treating
retroacting1447284retroacting
revegetating1753684revegetating
reverencing1743834reverencing
reverting132315134r__everting
revesting132814124r__evesting
revetting132912634r__evetting
rewetting132710444r__ewetting
sedimenting1563824sedimenting
selecting12310534__selecting
transfecting1855164transfecting
unaffecting2052164unaffecting
underacting1547524underacting
undereating1369554undereating

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 Filter1786911488190.420425454.8
2DLD Change Limit1488192158.14318275.7
3Display Results2152150.1231748.0
 (SQL Overall)1786912158.68620572.3
 
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.