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

202 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
ataxias1418934(None) 
ataxia13179591ataxia_
ataxics16196641ataxics
ataxies142410011ataxies
abasias9711012abasias
abaxial1646182abaxial
acacias11510392acacias
adaxial1545322adaxial
alexias14249792alexias
anoxias14259102anoxias
apraxias1746332apraxias
astasias8410142astasias
ataraxias1644312ataraxias
ataxic15169202ataxi_c
atonias73315992atonias
latakias1245582latakias
ratafias1145322ratafias
stadias8411112stadias
tafias93111962_tafias
taxies135817332_taxies
taxis126821972_taxi_s
aaliis6312893a_aliis
abacas104414723aba_cas
abakas123911743aba_kas
abasia8712953abasia_
abatis84317933abati_s
abaxile1644083abaxile
abayas114011703aba_yas
abelias93213563abelias
abulias93210693abulias
acacia10311353acacia_
acapnias1255683acapnias
acarids105312243acarids
acedias1039763acedias
acrasias1048893acrasias
actinias101810843actinias
adagial946363adagial
adagios945503adagios
agamas97413443aga_mas
agamids11317003agamids
agarics10319943agarics
agrias74315393a_grias
alanins7315803alanins
alaskas1136683alaskas
alexia132910463alexia_
alexins141910663alexins
alias55834603__alias
amanitas1048523amanitas
amias75831463__amias
amusias938573amusias
anabas8314083ana_bas
anaemias1069193anaemias
analgias9107793analgias
anemias92512143anemias
angarias9310543angarias
anopias92412473anopias
anoxia133510023anoxia_
antacids1148323antacids
antibias10312073antibias
anurias7312243anurias
aphagias14237343aphagias
aphasias132710433aphasias
aplasias10279233aplasias
aporias9315133aporias
apraxia1646893apraxia_
arabicas1247193arabicas
aramids102810503aramids
arcadias1149153arcadias
arias55438023__arias
asanas6514113asa_nas
astasia7310933astasia_
asterias8317003asterias
atabal839743ata_bal
atabals938413atabals
ataghan1144653ataghan
ataghans1244263ataghans
atalayas1144783atalayas
ataman81013063ata_man
atamans9710433atamans
ataps76414833ata__ps
ataraxia1544173ataraxia_
ataraxics1842693ataraxics
ataraxies1644723ataraxies
atavic11189293atavi_c
atavism1238033atavism
atavisms1346993atavisms
atavist10311093atavist
atavists1137573atavists
ataxy1537313atax__y
atlas55821583at__las
atmas75721013at__mas
atomics113110853atomics
atomies93918363atomies
atonia63816513atonia_
atonics93613713atonics
atonies75320953atonies
atopies92816433atopies
atresias839473atresias
atria56022333at_ria_
atrial65418943at_rial
attains7310983attains
attics84413283at_tics
attrits7310613attrits
auxins13129813a_uxins
avails939693ava_ils
awaits96411953awa_its
axial124515193__axial
axils127217503__axils
axis116127913__axi_s
azaleas1636993azaleas
battalias1144803battalias
biaxial1645363biaxial
braxies16711463braxies
capias10318353_capias
catalpas1246733catalpas
catawbas1544093catawbas
coaxial16157003coaxial
dataries9314033dataries
dystaxias20163233dystaxias
entasias8269143entasias
etamins91511823etamins
eutaxies1545793eutaxies
facias113415803_facias
fantasias1286993fantasias
galabias1137733galabias
galaxies1637163galaxies
gazanias1845733gazanias
italics936993italics
ixias12488363__ixias
lamias85020613_lamias
latakia1146093latakia_
latrias71913213lat_rias
mafias113913573_mafias
malarias10313753malarias
manias84029033_manias
maxims17399673_maxims
maxis145721563_maxi_s
otalgias944183otalgias
patacas11311003pata_cas
patagia1068783patagia_
patagial1157173patagial
praxis154012253praxi_s
raias54631123_ra_ias
ratafia1045773ratafia_
ratanies8312923ratanies
sataras7315053sata_ras
sharias102516003sharias
stadia7312143stadia_
staigs75414813sta_igs
stains64923653sta_ins
stairs65416333sta_irs
staminas1048853staminas
stanzas1636363stanzas
stasis63116873stasi_s
statics93314533statics
statins73719773statins
tablas83716163_tablas
taenias7311283taenias
taffias13377413taffias
tafia84215493_tafia_
taigas73712553_taigas
tails55634193_ta_ils
tains54936323_ta_ins
takas95520683_ta_kas
takins105117403_takins
talas55935893_ta_las
tamis76728723_tami_s
tankas104613763_tankas
tapas74627713_ta_pas
tapirs84113173_tapirs
tapis75028863_tapi_s
tarsias74013373tarsias
tatamis939713tatami_s
taxa116820093_tax_a_
taxers134015283_taxers
taxes124730823_tax_es
taxi117124763_taxi__
taxicab1843413_taxicab
taxicabs1942223_taxicabs
taxied14509373_taxied
taximan1635783_taximan
taxing143816713_taxing
taxite13511303_taxite
taxites1449673_taxites
taxiway2043463_taxiway
taxiways2142643_taxiways
taxman15328613_taxman
taxols13328633_taxols
taxons134211503_taxons
taxus125512483_tax_us
tazzas1436273_tazzas
tenias64720073_tenias
texas126514933_tex_as
tibias839943_tibias
titanias847103titanias
toxics153910203_toxics
toxins133314283_toxins
uranias72113813uranias
utopias9117723utopias
varias95019903_varias
yttrias1044513yttrias
zamias174212923_zamias

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.1401276364.3
2DLD Change Limit1340272027.47017942.0
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.68623248.9
 
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.