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

180 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
taffias1337741(None) 
maffias15327281maffias
raffias13237711raffias
taffia12286901taffia_
taffies133012691taffies
tafias93111961ta_fias
baffies153612942baffies
haffits1636192haffits
kaffirs17325552kaffirs
maffia14327202maffia_
mafias113913572ma_fias
raffia12287702raffia_
taenias7311282taenias
taffetas1442722taffetas
tafia84215492ta_fia_
tarsias74013372tarsias
tiffins13327982tiffins
toffies133210212toffies
traffics1644182traffics
waffies163611442waffies
zaffirs22375662zaffirs
affair1234353_affair
affairs1334163_affairs
affiant1348433_affiant
affiants1445233_affiants
affinal1336443_affinal
affine12310503_affine
affines1339483_affines
affirm1435523_affirm
affirms1534383_affirms
affix1836003_affi_x
affixal2043763_affixal
affixes2035503_affixes
affray1534973_affray
affrays1644063_affrays
afrits9311903_afrits
agrias74315393_agrias
alfas87219043_alf_as
alias55834603_a_lias
amias75831473_a_mias
arias55438023_a_rias
ataxias14189343ataxias
atonias73315993atonias
baffing164011603baffing
baffles153710683baffles
baffs134718053baff__s
biffies152710853biffies
biffins15358533biffins
boffins15329073boffins
caffeins1645123caffeins
caffs135417373caff__s
capias10318353ca_pias
cardias10715113cardias
cassias93514343cassias
coffins153110193coffins
daffier1457833daffier
daffiest1537843daffiest
daffily1735133daffily
daffing15369733daffing
daffs125116423daff__s
dahlias1135723dahlias
facias113415803fa_cias
fanfics1535173fanfics
fascias1258413fascias
gaffers14428713gaffers
gaffes134811103gaff_es
gaffing15379733gaffing
gaffs124914653gaff__s
gambias125010733gambias
haffets1636053haffets
haffit1538533haffi_t
jiffies20327473jiffies
kaffir16345303kaffi_r
kaffiyah2491573kaffiyah
kaffiyahs2571293kaffiyahs
kafirs13306983ka_firs
kalmias1347973kalmias
lamias85020613la_mias
latrias71913213latrias
luffas12337483luff_as
maffick2143523maffick
mafficks2243173mafficks
mafia104418033ma_fia_
maftirs1236043maftirs
manias84029033ma_nias
muffins15308343muffins
naffing14359033naffing
naffs116213963naff__s
nakfas1334683nakf_as
otalgias944183otalgias
puffins15278913puffins
raffish1658843raffish
raffles133611843raffles
raffs115017523raff__s
raias54631123ra__ias
raphias123511083raphias
ratafias1145323ratafias
ruffian1344133ruffian
ruffians1443793ruffians
salvias10279933salvias
soffits1335093soffits
stadias8411113sta_dias
staffers14247083staffers
staffing15247493staffing
staffs12349753staff__s
stiffies14258383stiffies
tabbies112913503tabbies
tabbis102910863tabbi_s
tablas83716163ta_blas
tactics1149323tactics
taenia6313193taenia_
taeniae739083taeniae
taffeta1343263taffeta
taffrail1442353taffrail
taffrails1542063taffrails
taffy145110823taff__y
tahsils1035053tahsils
taigas73712563ta_igas
tailfins1135443tailfins
tails55634193ta__ils
tains54936323ta__ins
takas95520683ta__kas
takins105117403ta_kins
talas55935893ta__las
talkies113415733talkies
tallies73624603tallies
tallis63319963talli_s
tallits73215993tallits
talukas11316213talukas
tameins9311413tameins
tamis76728733ta_mi_s
tammies113814683tammies
tankas104613763ta_nkas
tannins72813223tannins
tansies74521243tansies
tantras73112093tantras
tapas74627713ta__pas
tapirs84113173ta_pirs
tapis75028863ta_pi_s
taramas9612703taramas
tardies84225863tardies
tariffs1334593tariffs
tarries73324263tarries
tarsia65514273tarsia_
tassies74918933tassies
tatties74120343tatties
tawnies102812503tawnies
tawpies12309873tawpies
taxies135817333ta_xies
taxis126821973ta_xi_s
tazzas1436283ta_zzas
teffs115111733teff__s
tenias64720073t_enias
terbias9310743terbias
thorias102312053thorias
thulias1035743thulias
tibias839953t_ibias
tiffin12327933tiffi_n
tiffing14339383tiffing
tiffs114414883tiff__s
toffees13327083toffees
toffs116016723toff__s
traffic1544733traffi_c
tufas85314383t_uf_as
tuffets13266523tuffets
tuffs115118263tuff__s
varias95019903va_rias
waffie15338563waffi_e
waffing173710243waffing
waffles16329983waffles
waffs146315473waff__s
yaffing17337823yaffing
yaffs145311123yaff__s
yautias1046333yautias
zaffar21385043zaff_ar
zaffars22325233zaffars
zaffers22386773zaffers
zaffir21395513zaffi_r
zaffres22324993zaffres
zamias174212923za_mias

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 Limit1340271806.51620568.9
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.98525582.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.