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

211 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
raffias1323771(None) 
maffias15327281maffias
raffia12287701raffia_
taffias13377411taffias
baffies153612942baffies
haffits1636192haffits
kaffirs17325552kaffirs
maffia14327202maffia_
mafias113913572ma_fias
raffish1658842raffish
raffles133611842raffles
raffs115017522raff__s
raias54631122ra__ias
raphias123511082raphias
ratafias1145322ratafias
ruffian1344132ruffian
ruffians1443792ruffians
taffia12286902taffia_
taffies133012692taffies
tafias93111962ta_fias
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
amias75831463_a_mias
arias55438023_a_rias
baffing164011603baffing
baffles153710683baffles
baffs134718053baff__s
biffies152710853biffies
biffins15358533biffins
boffins15329073boffins
caffeins1645123caffeins
caffs135417373caff__s
capias10318353ca_pias
cardias10715093cardias
cassias93514343cassias
coffins153110193coffins
daffier1457833daffier
daffiest1537833daffiest
daffily1735133daffily
daffing15369733daffing
daffs125116423daff__s
dahlias1135723dahlias
draffier1574323draffier
draffiest1644353draffiest
draffish1844553draffish
draffs13617903draff__s
facias113415803fa_cias
fanfics1535173fanfics
fascias1258413fascias
gaffers14428713gaffers
gaffes134811103gaff_es
gaffing15379733gaffing
gaffs124914653gaff__s
gambias125010723gambias
graffiti1542983graffiti
graffitis1642713graffitis
graffito1542873graffito
griffins1544783griffins
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
paraffins1744643paraffins
puffins15278913puffins
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613153rabbi_s
rabbits11299863rabbits
rabies85226013ra_bies
rachial122012173rachial
rachis114017653rachi_s
racial83419243ra_cial
radial74020393ra_dial
radials83614633ra_dials
radian74117273ra_dian
radians83013823ra_dians
radios74018673ra_dios
radius73914863ra_dius
radulas839583radulas
raff104933043raff___
raffinate1545023raffinate
raffinates1644363raffinates
raffinose1542193raffinose
raffle123910703raff_le
raffled14429083raffled
raffler13339223raffler
rafflers14317363rafflers
rafflesias1651523rafflesias
raffling1567063raffling
rafters103715633rafters
rafting113815753rafting
rafts87820633ra_f_ts
ragas65326063ra__gas
raggies93214733raggies
ragis66325603ra_gi_s
raia46638383ra__ia_
raids65827513ra__ids
rails55937403ra__ils
rains55140233ra__ins
rais45252623ra__i_s
raisins72715343raisins
raitas64417673ra_itas
rajas127317723ra__jas
rakis95323443ra_ki_s
rallies73823343rallies
ramadas1039303ramadas
ramblas112710263ramblas
ramies84630463ra_mies
ramifies13310503ramifies
ramonas9311093ramonas
ramtils938413ramtils
randies84225663randies
ranids75118703ra_nids
ranis55235833ra_ni_s
ranulas7311773ranulas
raphia113511263raphia_
raphis114014323raphi_s
rapids94913893ra_pids
rarefies1138993rarefies
rarifies11311933rarifies
ratafia1045773ratafia_
ratfink1434943ratfink
ratfinks1542853ratfinks
ratfish1338773ratfish
ratifies11313513ratifies
ratios64922673ra_tios
ratlins73615583ratlins
ravins94622563ra_vins
rawins95617623ra_wins
rayas85922053ra__yas
reaffirm1642483reaffirm
reaffirms1741943reaffirms
reaffix2042323reaffi_x
reaffixes2243023reaffixes
redfins1139923redfins
redias74523603r_edias
reffing143712173reffing
refits94017653r_efits
reflies104418533reflies
refries104419733refries
reifies104218283reifies
rias45540593r___ias
riffing144011273riffing
riffles133911163riffles
riffs115114613riff__s
riflips1234163riflips
roofies103014413roofies
ruffes124112423ruff_es
ruffing143210843ruffing
ruffles133512263ruffles
ruffs114516743ruff__s
salvias10279933salvias
soffits1335093soffits
taenias7311283taenias
taffetas1442723taffetas
tafia84215493ta_fia_
tarsias74013373tarsias
tiffins13327983tiffins
toffies133210213toffies
traffic1544733traffi_c
uraemias1046043uraemias
uranias72113813ura_nias
varias95019903va_rias
waffie15338563waffi_e
waffing173710243waffing
waffles16329983waffles
waffs146315473waff__s
yaffing17337823yaffing
yaffs145311123yaff__s
yautias1046333yautias
zaffar21385043zaff_ar
zaffars22325233zaffars
zaffers22386773zaffers
zaffir21395513zaffi_r
zaffres22324993zaffres
zamias174212923za_mias

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272118.00016753.4
3Display Results2112110.1261674.6
 (SQL Overall)1786912118.27921583.6
 
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.