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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
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
atap66722451atap
aa219179952a_a_
aah616252962a_ah
aal39058672a_al
aas310975392a_as
aba512850952aba_
abas68642082abas
acta69524802acta_
afar76720782afar
aga410447232aga_
agar58726412agar
agas55938842agas
aha611246642aha_
ajar116217702ajar
ala312463602ala_
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
altar55520642altar
ama510853302ama_
amah98927492amah
amas67746292amas
ana39559832ana_
anal48037522anal
anas46649862anas
anta46839582anta_
antae56828292antae
antas55432032antas
arak86929572arak
artal55525472artal
at212393402at__
ataps76414832ataps
ataxy1537312ataxy
ate37059242at_e
ates45047922ates
atlas55821582atlas
atma68121772atma
atman75520142atman
atmas75721012atmas
atom67824522atom
atop66124752atop
att35454652at_t
attar56516692attar
ava610139322ava_
awa611939672awa_
away108024222away
axal116520492axal
ayah108022992ayah
azan136521782azan
data56026652data_
eta35834192eta_
etas46432272etas
fatal84819372fatal
kata85626022kata_
katas95922092katas
natal53921492natal
ratal55025112ratal
ratan53722662ratan
satay84718462satay
stab67329932stab
stag57332002stag
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
ta211662452_ta_
tab57460322_tab
tad47959822_tad
tae38267052_tae
tag47259492_tag
taj106442192_taj
tam58663422_tam
tan37167572_tan
tao38358952_tao
tap57663872_tap
tar37570692_tar
tas38477102_tas
tat37690292_tat
tatar56122062tatar
tau36856902_tau
tav66043212_tav
taw610155452_taw
tax109449152_tax
uta37425582uta_
utas45924952utas
watap102111672watap

Search took 2 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 Filter178691298720.313570897.8
2DLD Change Limit29872871.29623049.4
3Display Results87870.0136692.3
 (SQL Overall)178691871.622110167.1
 
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.