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

87 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
jetbead174298(None) 
jetbeads1842481jetbeads
jetted143915082jette_d
retread849002retread
antbear935063antbear
bead75937923___bead
beebread1343243beebread
behead1239923be_head
bestead10389113bestead
betted94721163bette_d
cathead1338753cathead
debeak1336763de_beak
debeard1137353de_beard
delead84112343de_lead
ebbed104111003_ebbe_d
embed105014303_embe_d
ennead736253_ennead
fathead1437863fathead
feted94420933fet_e_d
fetted104817893fette_d
herbed123513453herbe_d
hotbed123310683hotbe_d
hothead14349293hothead
jabbed184213483jabbe_d
jambeau1843773jambeau
jambed184811403jambe_d
jarhead1835173jarhead
jeaned143813463jeane_d
jebel145612143je_be_l
jebels15418913je_bels
jeed125428503je__e_d
jeeped16469843jeepe_d
jeered143912793jeere_d
jehad1637683je__had
jelled144916063jelle_d
jerboa1535633jerboa_
jerboas1636163jerboas
jereed144012073je_reed
jerked18479593jerke_d
jerreed1535213jerreed
jessed144112303jesse_d
jested144416503jeste_d
jete115927253jet_e__
jetes124922843jet_e_s
jetlag1434523jet_lag
jetsam15116323jet_sam
jettied15366973jettied
jetway19105273jet_way
jewed165114833je_we_d
jibbed184810563jibbe_d
jibed155114163j_ibe_d
jobbed184212133jobbe_d
jotted143615173jotte_d
jughead1933643jughead
jutted144315023jutte_d
kerbed13339703kerbe_d
lethean1037093lethean
letted74118543lette_d
meathead1436793meathead
meted85424433met_e_d
metred95315143metre_d
netted74118713nette_d
outbeam1137973outbeam
outlead83311103outlead
outread82811093outread
petted94121523pette_d
pithead13419593pithead
pothead133810393pothead
redhead1257053redhead
replead10399013replead
reread71715433re_read
reteam83214533ret_eam
retear63115483ret_ear
rethread1245353rethread
retied75924983retie_d
retreads937823retreads
retreat7317533retreat
retted74826313rette_d
seabed95017693seabe_d
stead65520273_st_ead
tetrad73612053tet_rad
tread64821703__tread
untread857413untread
vetoed10359823vetoe_d
vetted104316323vette_d
webbed1436433webbe_d
wetted103717023wette_d

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 Filter1786911340270.406440125.6
2DLD Change Limit134027875.71623447.7
3Display Results87870.0332636.4
 (SQL Overall)178691876.15529031.8
 
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.