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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
dehisced158368(None) 
dehisce13104271dehisce_
dehisces1464711dehisces
dehiscent1545492dehiscent
deiced104214482de_i_ced
delisted10310562delisted
demised113613682demis_ed
desisted1039782desisted
devised123712562devis_ed
dezinced2183902dezinced
disced104914652d__isced
bekissed1543163bekissed
bemisted1368383bemisted
daisied93410013d_aisied
deaired9411533deai_red
deashed123411303de_ashed
debased113310583debas_ed
debited113311623debi_ted
decided124312423deci_ded
deduced1266683de_duced
defaced142910973de_faced
defenced1537203defenced
defied115016383defi__ed
defiled124013103defi_led
defined123813823defi_ned
deforced15247373deforced
defused125211093defus_ed
degassed11275963degassed
degusted1135733degusted
dehiscence1854383dehiscence
dehiscing1643733dehiscing
dehorned1345683dehorned
dehorted1357303dehorted
deice84320033de_i_ce_
deicer94114413de_i_cer
deices94119373de_i_ces
deified123112413de_ified
deigned1037503de_igned
delimed11310723deli_med
demasted1238763demasted
demise94618323demis_e_
demises103719563demis_es
demister11310223demister
demitted12288773demitted
denied84318633deni__ed
denimed1159233deni_med
depicted1437743depicted
deposed113412023depos_ed
derided102914253deri_ded
derived123912763deri_ved
descend11248153de__scend
designed1136943designed
desired9311983desi_red
despised1236923despis_ed
detested10279623detested
deticked1635693deticked
deuced104112123de__uced
devested13239133devested
deviated13311043deviated
device124512163devi_ce_
devices133212583devi_ces
deviled124112183devi_led
devilled1336743devilled
devise104215753devis_e_
devisee113812713devis_ee
devisees12358283devisees
deviser114212393devis_er
devises114116763devis_es
devoiced15276063devoiced
dezincked2691643dezincked
diced95824683d__i_ced
discoed11312483d__iscoed
dished114318713d__ished
disked125015763d__isked
dissed85220183d__issed
enisled82510223_enisled
evinced1335403_evinced
existed1538473_existed
heisted113210653he_isted
hissed104114453__hissed
histed104420243__histed
peised94817683pe_is_ed
perished14310083perished
rehashed1536063rehashed
rehinged1336853rehinged
rehired115013153rehi_red
relished1239433relished
relisted9312623relisted
remised103516843remis_ed
resisted9312693resisted
revised113815483revis_ed
seised74218123se_is_ed
whished17428023_whished
whisked18336913_whisked
whisted144010013_whisted

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.420425454.8
2DLD Change Limit146162956.98620922.1
3Display Results95950.0303166.7
 (SQL Overall)178691957.43624030.5
 
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.