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

67 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
predeath144700(None) 
predeaths1544741predeaths
predate10616892pred_ate
predebate1446162predebate
preheat12413892preheat_
preheats1339412preheats
beneath1236973_beneath
breath113916263br__eath
credent10313973credent_
death94822523___death
greenth11116723gre_enth
pedate93117763p_ed_ate
permeate12311613permeate
preach133613923pr__each
prebirth1543463prebirth
precent113520263precent_
precents123015043precents
precept133112513precept_
precepts14268893precepts
precrash1544823precrash
predated12513273pred_ated
predates11615813pred_ates
predator11310053pred_ator
predawn1335353pred_awn
predella1145393predella
predial103815413predia_l
predicate14411783predicate
predict12315323predict_
predicts1339613predicts
predraft1447593predraft
preedit10512463preedit_
preedits1168763preedits
prefect141011073prefect_
prefects1598133prefects
preheated1539813preheated
preheater1448913preheater
prelate9519693pre_late
prelect111013833prelect_
prelects1299723prelects
premeal11310523premea_l
premeet11615153premeet_
present94022733present_
presents103315643presents
preset84430983prese_t_
presets94216423prese_ts
pretest9517633pretest_
pretests10310013pretests
pretext1639663pretext_
pretexts1735603pretexts
pretreat10311923pretreat_
pretreats1146933pretreats
prevent124016553prevent_
prevents133012293prevents
prewash1535213pre_wash
preweigh1753683preweigh
prudent10310433prudent_
redate74124683_red_ate
redear73515173_redea_r
redears82814453_redears
reheat94423943_reheat_
reheats104513523_reheats
repeat85127213_repeat_
repeats94316053_repeats
reseat64131493_reseat_
reseats74319583_reseats
reteach1237413_reteach
wreath124111193wr__eath

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.436409841.7
2DLD Change Limit146162677.17320376.7
3Display Results67670.0302233.3
 (SQL Overall)178691677.63923391.9
 
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.