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

121 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
detruded113488(None) 
detrude936081detrude_
detrudes1036201detrudes
debrided1336582debrided
defrauded1542822defrauded
degraded12288322degraded
deluded10158762de_luded
denuded10167662de_nuded
derided102914252de_rided
detoured1036512detoured
extruded1743842extruded
intruded1035992intruded
obtruded1243362obtruded
bearded114212133bear_ded
begrudged1562333begrudged
belauded1244793belauded
betided114810203bet_ided
betrayed1436303betrayed
debride1138593debride_
debrides1268723debrides
debruised1343003debruised
debuted11379333de_buted
decided124312423de_cided
decoded123212383de_coded
decreed112710253decr_eed
decried112612853decr_ied
decurved1534843decurved
deduced1266683de_duced
deeded94615543de__eded
deerweed1344183deerweed
defended1437223defended
defrauder1442533defrauder
defrayed1635403defrayed
defunded1435163defunded
defused125211093de_fused
defuzed21447043de_fuzed
degrade10229903degrade_
degrader11247913degrader
degrades11269923degrades
degreed10258883degr_eed
deleaded1148333deleaded
deloused1036973deloused
delude81910673de_lude_
deluder9168333de_luder
deludes91810643de_ludes
deluged10167413de_luged
demanded13348513demanded
demoded123611123de_moded
demurred1234933demurred
denude8169353de_nude_
denuder9167603de_nuder
denudes91510043de_nudes
depended1337983depended
deplumed1434083deplumed
depraved1535543depraved
deprived1546463deprived
deputed114610173de_puted
derated93623503de_rated
deride84420033de_ride_
derider93214973de_rider
derides93420853de_rides
derived123912763de_rived
desanded11227453desanded
destroyed1445083destroyed
destructed1445413destructed
detached1537733detached
detailed10319873detailed
detained103111643detained
detected12289733detected
deterged11127923deterged
deterred10137803deterred
detested10279623detested
dethroned1445073dethroned
deticked1635693deticked
detoxed1636103det_oxed
detracted1357793detracted
detrained1158913detrained
detruding1245193detruding
deuced104112123de__uced
devoured1335723devoured
drudged11277613d__rudged
duded84417133d___uded
eluded84612773_e_luded
eroded84313583_e_roded
etude63612303_et_ude_
etudes73811603_et_udes
extrude1545013extrude_
extruder1643993extruder
extrudes1645243extrudes
exuded15317683_e_xuded
ferruled1263923ferruled
feruled11318423fe_ruled
feuded114010003fe__uded
herded114215643he_r_ded
intrude837403intrude_
intruder945213intruder
intrudes937493intrudes
metred95315143metr__ed
nitrided10276753nitrided
obtrude1044243obtrude_
obtruder1143093obtruder
obtrudes1144073obtrudes
peruked14367893pe_ruked
perused103112193pe_rused
protruded1343443protruded
regraded113410763regraded
retarded102410753retarded
retraced111413023retraced
retreaded1137053retreaded
retried84419153retr_ied
retuned86613973ret_uned
returned9459133returned
secluded1233663secluded
strudel835783_strudel
tetrode839343tetrode_
tetrodes939093tetrodes
traded85717683__traded
truced95312053__truced
trudged10298043__trudged
trued65117693__tru_ed
weirded1234513weir_ded

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621217.42319690.4
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.87522690.9
 
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.