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

102 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
deflecting173650(None) 
defecting162510221def_ecting
reflecting1638821reflecting
beflecking2243032beflecking
defeating142311972def_eating
defecating17237782def_ecating
deflating142610712defl_ating
defleaing1444742defle_aing
deflection16147732deflection
deflections17187322deflections
deflective1956092deflective
dejecting20217792de_jecting
deleting103314422de_le_ting
depleting1378192deple_ting
deselecting1544472deselecting
detecting13259982de_tecting
effecting1845582_effecting
electing112113782_e_lecting
inflecting1646312inflecting
neglecting1444542neglecting
reelecting1338782reelecting
refecting152413352ref_ecting
selecting12310532se_lecting
affecting1845233_affecting
afflicting1943483afflicting
befleaing1544023befle_aing
befretting1644793befretting
collecting1548283collecting
decocting1538123de_cocting
deducting1436843de_ducting
defacing15238683def_ac_ing
defalcating1844343defalcating
defatting1436103def_atting
defaulting1543393defaulting
defection151610643def_ection
defections161510203def_ections
defective1848003def_ective
defencing16226693def_encing
defending15298353def_ending
defensing14217003def_ensing
deferring1436143def_erring
deflect13399973deflect___
deflected1635983deflect_ed
deflector1555063deflect_or
deflectors1654773deflectors
deflects14336733deflect__s
defoliating1645823defoliating
deforcing1636063deforc_ing
deforesting1654793deforesting
defrocking2143153defrocking
defrosting1544493defrosting
defueling14255093defue_ling
defuelling1573543defuelling
delating103119603de_l_ating
deleading1237773de_leading
deleaving1436263de_leaving
delectating1545993de_lectating
delegating1337673de_legating
deleing93313953de_le__ing
delisting112710503de_listing
dementing13311043de_menting
depicting1537813de_picting
deprecating1777283deprecating
deserting11713143de_serting
detesting112610323de_testing
detracting1438713detracting
devesting14249903de_vesting
directing1338823d_irecting
disjecting2177243disjecting
dissecting14139473dissecting
ejecting18268163_e_jecting
erecting112415063_e_recting
expecting2146693_expecting
exsecting1935933_exsecting
flecking18408233__flecking
fleeting122910323__fleeting
genuflecting1961253genuflecting
infecting15109673inf_ecting
inflicting1645723inflicting
leafleting1442893leafle_ting
leafletting1541983leafletting
pelleting1237953pelle_ting
perfecting1847513perfecting
preelecting1646473preelecting
prelecting15310163prelecting
redefecting1844373redef_ecting
reejecting2045813reejecting
reerecting1339973reerecting
reflating132514713refl_ating
reflection15168993reflection
reflections16178553reflections
reflective1857123reflective
reflexing2035933refle_xing
refloating14198323refloating
refracting1638733refracting
rejecting192211153re_jecting
relenting102716773re_lenting
reletting102713943re_letting
relucting1239773re_lucting
resecting122816483re_secting
reselecting1446023reselecting
respecting1549883respecting

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 Filter1786911406030.440406115.9
2DLD Change Limit1406031026.28022389.0
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.76626410.1
 
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.