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

80 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
haftaras1413607(None) 
haftara13136091haftara_
haftarah17124171haftarah
haftarahs18133271haftarahs
haftarot1446172haftarot
hafters134614332hafter_s
haftorah17123922haftorah
haftorahs18133452haftorahs
haftoros1444172haftoros
haphtaras1753442haphtaras
sataras7315052sa_taras
tantaras8269532tantaras
afars85716513_af_ar_s
afters94717073_after_s
aftosas10147143_aftosas
altars64518153_altar_s
attars64515313_attar_s
baccaras1446913baccaras
bastards113310313bastards
caftans12179443cafta_ns
cantalas104013523cantalas
cantatas103410083cantatas
cascaras1237693cascaras
dastards10278083dastards
daturas838763da_turas
haars85620473ha__ar_s
haftaroth1852663haftaroth
hafter124815883hafter__
haftorot1445773haftorot
hafts116219463haft___s
haggadas1463613haggadas
haggards14366763haggards
halalas104214083ha_lalas
halteres113414593halteres
halters104619803halter_s
halyards1576243halyards
hamadas1339663ha_madas
hammadas1644783hammadas
hangars114313483hangar_s
haphtara1653273haphtara_
haphtarah1662113haphtarah
haphtarahs1761903haphtarahs
harianas1139163harianas
hartals10313023harta_ls
haters94930393ha_ter_s
hatterias1258733hatterias
hatters104221523hatter_s
hawalas13348353ha_walas
haywards1845873haywards
hazards2037463ha_zards
hectares1338853hectares
hefters134312003hefter_s
hektares1535813hektares
hetaeras1146723h_etaeras
hetairas1145603h_etairas
kaftans14185353kafta_ns
kantars11310033kantar_s
lantanas838263lantanas
maftirs1236043maftir_s
mantras93815863mant_ras
mascaras1237693mascaras
mastabas1246803mastabas
patacas11311003pa_tacas
rafters103715633rafter_s
safaris101110663saf_aris
samaras9312913sa_maras
samsaras1045873samsaras
santeras8311053santeras
satara6315533sa_tara_
tantara72410813tantara_
tantras73112093tant_ras
tartanas8258893tartanas
tartars73313403tartar_s
tatars64619793ta_tar_s
tuataras844853tuataras
waftages15105393waftages
wafters134112813wafter_s
waftures1434853waftures
yantras10259003yant_ras
zaffars22325233zaffar_s

Search took 9 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.1531167915.0
2DLD Change Limit146162808.12617987.0
3Display Results80800.0302666.7
 (SQL Overall)178691808.30921505.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.