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

175 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
zaffre2135466(None) 
zaffer21397151zaffer
zaffres22324991zaffres
afire86215912_afire
afore85818602_afore
baffle14399872baffle
gaffe124111652gaff_e
gaffer134310132gaffer
raffle123910702raffle
waffie15338562waffie
waffle15369182waffle
zaffar21385042zaffar
zaffars22325232zaffars
zaffers22386772zaffers
zaffir21395512zaffir
zaffirs22375662zaffirs
zaire14311992za_ire
acre67330773_a_cre
adore65723663_adore
afar76720783_afar_
afars85716513_afars
aff95537613_aff__
affaire1344463_affaire
affine12310503_affine
affirm1435523_affirm
affix1836003_affix
afford1346493_afford
affray1534973_affray
after85719793_after
antre55224523_antre
are37874573_a__re
aware86420023_aware
azure14911483_azure
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffled16418063baffled
baffler15418113baffler
baffles153710683baffles
baffs134718053baff_s
baffy165511923baff_y
bare65460523ba__re
barre75929543ba_rre
before11410153before
buffer144512683buffer
cadre85419013ca_dre
cafe95230323ca_f_e
caff125631673caff__
caffs135417373caff_s
care66968373ca__re
carfare12310073carfare
chaffer18389473chaffer
coffee144113743coffee
coffer144112863coffer
coffle14359043coffle
coffret15310073coffret
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffs125116423daff_s
daffy155510283daff_y
dafter104813343dafter
dare55848863da__re
deffer134411303deffer
differ133910843differ
doffer133911353doffer
duffer134711663duffer
duffle13368533duffle
eagre64315323ea_gre
fanfare1336673fanfare
fare76354463__fare
fere76342233__fere
fire76245593__fire
fore78351473__fore
gaff114828153gaff__
gaffed144210203gaffed
gaffers14428713gaffers
gaffes134811103gaffes
gaffs124914653gaff_s
galere73716673galere
galore73514843galore
gauffer1474423gauffer
goffer13409513goffer
haffet15311703haffet
haffit1538533haffit
hafter124815883hafter
hare76255733ha__re
infare9313083infare
kaffir16345303kaffir
kaffirs17325553kaffirs
kafir12488903kafir_
kafirs13306983kafirs
madre85720173ma_dre
maffia14327203maffia
maigre9309163maigre
malgre9299303malgre
manure8313653manure
mare64759323ma__re
mature8313463mature
maugre9308973maugre
muffle14339643muffle
nacre75715363na_cre
naff105128933naff__
naffed13408333naffed
naffs116213963naff_s
nature6311263nature
niffer12378443niffer
offer114311383_offer
padre86018163pa_dre
palfrey1533343palfrey
panfry14456413panfry
pare66760843pa__re
parure8312523parure
piaffe1494913piaff_e
piaffer15104443piaffer
piffle14418233piffle
puffer144610733puffer
quaffer2235133quaffer
raff104933043raff__
raffia12287703raffia
raffled14429083raffled
raffler13339223raffler
raffles133611843raffles
raffs115017523raff_s
rafter94517583rafter
rare45348433ra__re
rasure6311423rasure
refire95419473refire
riffle124210233riffle
ruffe114713813ruff_e
ruffle124111673ruffle
sabre74821503sa_bre
safari91110223safari
safe75930953sa_f_e
safer84721813safer_
saffron1344173saffron
satire63218003satire
snaffle13216243snaffle
staffer13299093staffer
suffer124314513suffer
taffarel1442563taffarel
tafferel1443123tafferel
taffia12286903taffia
taffies133012693taffies
taffy145110823taff_y
tare45957623ta__re
tarre55825633ta_rre
toffee123311013toffee
wafer114417643wafer_
wafered14288433wafered
wafers124316143wafers
wafery15398693wafery
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
waffled17357523waffled
waffler16377783waffler
waffles16329983waffles
waffly18305433waffly
waffs146315473waff_s
wafter124114613wafter
wafture1334853wafture
ware76254723wa__re
warfare1336733warfare
yaff135324263yaff__
yaffed16457323yaffed
yaffs145311123yaff_s
yare75636943ya__re
zaftig1933253zaftig
zaires1539703za_ires
zander163417113zander
zanier154314713zanier
zapper193414023zapper
zarf166929123za__rf
zarfs174713623zarf_s

Search took 6 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.1401276364.3
2DLD Change Limit1127161755.75019602.8
3Display Results1751750.0632777.8
 (SQL Overall)1786911755.95330017.0
 
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.