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

235 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
raffia1228770(None) 
maffia14327201maffia
raffias13237711raffias
taffia12286901taffia
affix1836002_affix
haffit1538532haffit
kaffir16345302kaffir
maffias15327282maffias
mafia104418032ma_fia
raff104933042raff__
raffish1658842raffish
raffle123910702raffle
raffs115017522raff_s
raia46638382ra__ia
raphia113511262raphia
ratafia1045772ratafia
reaffix2042322reaffix
ruffian1344132ruffian
taffias13377412taffias
tafia84215492ta_fia
traffic1544732traffic
waffie15338562waffie
zaffir21395512zaffir
aecia73819283_aecia
aff95537613_aff__
affair1234353_affair
affiant1348433_affiant
affinal1336443_affinal
affine12310503_affine
affirm1435523_affirm
affixal2043763_affixal
affray1534973_affray
afrit8323173_afrit
agria65517143_agria
alfa77624273_alf_a
amia66836903_a_mia
amnia75918643_amnia
aria46245423_a_ria
atria56022343_atria
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffing164011603baffing
baffle14399873baffle
baffs134718053baff_s
baffy165511923baff_y
biffin14369103biffin
boffin14359053boffin
brachia141910423brachia
buffi136112203buffi_
caff125631673caff__
caffein1535333caffein
caffs135417373caff_s
cambia124913153cambia
cardia9916383cardia
cassia83714763cassia
coffin14339813coffin
crania82418433cra_nia
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffily1735133daffily
daffing15369733daffing
daffs125116423daff_s
daffy155510283daff_y
dahlia1035773dahlia
draff125615663draff__
draffier1574323draffier
draffish1844553draffish
draffs13617903draff_s
draffy16486633draff_y
facia103218463fa_cia
fanfic1436313fanfic
fascia1148703fascia
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffing15379733gaffing
gaffs124914653gaff_s
gambia115912253gambia
graffiti1542983graffiti
graffito1542873graffito
griffin1434513griffin
haffet15311703haffet
haffits1636193haffits
hafiz20611213ha_fiz
kaffirs17325553kaffirs
kaffiyah2491573kaffiyah
kafir12488903ka_fir
kalmia1238893kalmia
labia75219013la_bia
lamia75324323la_mia
latria62313603latria
luffa11409023luff_a
maffick2143523maffick
mafias113913573ma_fias
mafic125615463ma_fic
maftir1136493maftir
mania75634153ma_nia
maria75032883ma_ria
muffin14298873muffin
naff105128933naff__
naffed13408333naffed
naffing14359033naffing
naffs116213963naff_s
nakfa1236093nakf_a
pallia83015593pallia
paraffin1644903paraffin
puffin141149003puffin
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabic93817403ra_bic
rabid84520783ra_bid
rachial122012173rachial
rachis114017653rachis
racial83419243ra_cial
radial74020393ra_dial
radian74117273ra_dian
radii64016413ra_dii
radio64922493ra_dio
radix134414603ra_dix
radula749313radula
raffinate1545023raffinate
raffled14429083raffled
raffler13339223raffler
raffles133611843raffles
rafflesia1551553rafflesia
raffling1567063raffling
raft76245913ra_f_t
rafted104714703rafted
rafter94517583rafter
rafting113815753rafting
rafts87820633ra_fts
raga55930813ra__ga
ragi56032283ra_gi_
ragis66325603ra_gis
rai37658223ra__i_
raias54631123ra__ias
raid55243073ra__id
rail46147763ra__il
rain46251733ra__in
rais45252623ra__is
raisin62716923raisin
raita54623073ra_ita
raja117918683ra__ja
raki87127833ra_ki_
rakis95323443ra_kis
ramada9310183ramada
rambla103510933rambla
rami66034093ra_mi_
ramie75027823ra_mie
ramify14268753ramify
ramona8412413ramona
ramtil8311033ramtil
rancid9513863rancid
rani46640113ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
ranula6311813ranula
raphias123511083raphias
raphis114014323raphis
rapid86422033ra_pid
rarify123210063rarify
ratafias1145323ratafias
ratfink1434943ratfink
ratfish1338773ratfish
ratify122610043ratify
ratio55227583ra_tio
ratlin64116523ratlin
ravin85624653ra_vin
rawin85521473ra_win
raya75224823ra__ya
reaffirm1642483reaffirm
realia6314593realia
redfin10310223redfin
redia65524483r_edia
reffed134712513reffed
reffing143712173reffing
refit84230063r_efit
refix155212483r_efix
refugia1144313refugia
retia55326113r_etia
ria36745503r___ia
riff104430103riff__
riffed133811563riffed
riffing144011273riffing
riffle124210233riffle
riffs115114613riff_s
riflip1134723riflip
roofie93411173roofie
ruff105127653ruff__
ruffe114713813ruff_e
ruffed134312743ruffed
ruffes124112423ruffes
ruffians1443793ruffians
ruffing143210843ruffing
ruffle124111673ruffle
ruffly15336673ruffly
ruffs114516743ruff_s
salvia93310753salvia
soffit1237883soffit
suffix1935233suffix
taenia6313193taenia
taffeta1343263taffeta
taffies133012693taffies
taffy145110823taff_y
tafias93111963ta_fias
tarsia65514273tarsia
tiffin12327933tiffin
traffics1644183traffics
uraemia946503uraemia
urania62516123ura_nia
varia85824203va_ria
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
waffing173710243waffing
waffle15369183waffle
waffly18305433waffly
waffs146315473waff_s
yaff135324263yaff__
yaffed16457323yaffed
yaffing17337823yaffing
yaffs145311123yaff_s
yautia937253yautia
zaffar21385043zaffar
zaffer21397153zaffer
zaffirs22375663zaffirs
zaffre21354663zaffre
zaftig1933253zaftig
zamia165115213za_mia

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162355.70319764.3
3Display Results2352350.0603916.7
 (SQL Overall)1786912356.15329041.3
 
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.