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

110 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
haftara1313609(None) 
haftarah17124181haftarah
haftaras14136071haftaras
haftarahs18133272haftarahs
haftarot1446172haftarot
hafter124815882hafter_
hafters134614332hafters
haftorah17123932haftorah
haphtara1653272haphtara
satara6315532sa_tara
tantara72410822tantara
afar76720783_af_ar_
afars85716513_af_ars
afeard1058263_afeard
after85719793_after_
afters94717073_afters
aftosa996573_aftosa
altar55520643_altar_
altars64518153_altars
antra56521923_ant_ra
attar56516693_attar_
attars64515313_attars
baccara1347143baccara
bastard103012423bastard
caftan111710123cafta_n
caftans12179443caftans
cantala94114673cantala
cantata93811813cantata
cascara1138313cascara
dafter104813343dafter_
dastard9279703dastard
datary10310243da_tary
datura738033da_tura
haar77323493ha__ar_
haars85620473ha__ars
haft105941843haft___
haftaroth1852663haftaroth
hafted134713833haft_ed
hafting144014173hafting
haftorahs18133463haftorahs
haftoros1444173haftoros
haftorot1445773haftorot
hafts116219463haft__s
haggada1353643haggada
haggard13377183haggard
halala94715093ha_lala
halter94420883halter_
haltere103614713haltere
halters104619803halters
halyard1476973halyard
hamada1239923ha_mada
hammada1545093hammada
hangar104114513hangar_
hangars114313493hangars
haphtarah1662113haphtarah
haphtaras1753443haphtaras
hariana10310243hariana
hartal9415473harta_l
hartals10313023hartals
hastate10313913hastate
hater85034753ha_ter_
haters94930403ha_ters
hatter94724873hatter_
hatteria1137863hatteria
hatters104221523hatters
hawala12368913ha_wala
hayward1736413hayward
hazard1938403ha_zard
hectare1238463hectare
hefter124313923hefter_
hefters134312003hefters
hektare1435503hektare
hetaera1036493h_etaera
hetaira1045903h_etaira
kaftan13185823kafta_n
kaftans14185353kaftans
kantar10311153kantar_
kantars11310033kantars
labara83712893la_bara
lactary1237853lactary
lantana739603lantana
maftir1136493maftir_
maftirs1236043maftirs
mantra84116093mant_ra
mascara1138023mascara
mastaba1146223mastaba
pataca10311193pa_taca
rafter94517583rafter_
rafters103715633rafters
safari91110223saf_ari
samara8313853sa_mara
samsara936913samsara
santera7311303santera
sataras7315063sa_taras
tantaras8269543tantaras
tantra63713353tant_ra
tartana73010193tartana
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
tatar56122063ta_tar_
tatars64619793ta_tars
tuatara745513tuatara
waftage14115323waftage
wafter124114613wafter_
wafters134112813wafters
wafture1334853wafture
yantra9449623yant_ra
zaffar21385043zaffar_
zaffars22325233zaffars

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271107.36018210.2
3Display Results1101100.0303666.7
 (SQL Overall)1786911107.79622920.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.