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

171 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
zaffar2138504(None) 
zaffars22325231zaffars
zaffer21397151zaffer
zaffir21395511zaffir
afar76720782_a_far
affair1234352_affair
gaffer134310132gaffer
kaffir16345302kaffir
zaffers22386772zaffers
zaffirs22375662zaffirs
zaffre21354662zaffre
afars85716513_a_fars
afeard1058263_afeard
aff95537613_aff__
affaire1344463_affaire
affairs1334163_affairs
affirm1435523_affirm
affix1836003_affix
afford1346493_afford
affray1534973_affray
after85719793_after
agar58726413_a_gar
ajar116217703_a_jar
alar46340073_a_lar
alfa77624273_alfa_
alfas87219043_alfas
altar55520643_altar
anear55420323_anear
attar56516693_attar
aurar54420253_aurar
baff124632263baff__
baffed154812173baffed
baffle14399873baffle
baffler15418113baffler
baffs134718053baff_s
baffy165511923baff_y
bazaar17306403bazaar
bazar163816003ba_zar
buffer144512683buffer
caesar8410933caesar
caff125631673caff__
caffs135417373caff_s
caftan111710123caftan
calcar10312753calcar
carfare12310073carfare
caviar11310163caviar
chaffer18389473chaffer
coffer144112863coffer
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffs125116423daff_s
daffy155510283daff_y
dafter104813343dafter
damar84117733da_mar
dammar11438903dammar
darbar959953darbar
deffer134411303deffer
differ133910843differ
doffer133911353doffer
duffer134711663duffer
fanfare1336673fanfare
far67762603___far
farfal123410183farfal
fear75337793__fear
fiar76427333__fiar
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffers14428713gaffers
gaffes134811103gaffes
gaffs124914653gaff_s
gauffer1474423gauffer
gaydar1135503gaydar
gazar154612983ga_zar
goffer13409513goffer
guffaw1642793guffaw
haar77323493ha__ar
haffet15311703haffet
haffit1538533haffit
haftara13136093haftara
hafter124815883hafter
hangar104114503hangar
jaguar1435283jaguar
kabar114815553ka_bar
kaffirs17325553kaffirs
kafir12488903ka_fir
kaftan13185823kaftan
kantar10311153kantar
lahar83114263la_har
lascar868573lascar
lazar144113643la_zar
luffa11409023luffa_
luffas12337483luffas
maar66025053ma__ar
maffia14327203maffia
maffias15327283maffias
mafia104418033mafia_
mafias113913573mafias
maftir1136493maftir
makar115614973ma_kar
malar76424443ma_lar
naff105128933naff__
naffed13408333naffed
naffs116213963naff_s
nakfa1236093nakfa_
nakfas1334683nakfas
navar83912733na_var
niffer12378443niffer
offal1136243_offal
offer114311383_offer
palmar104113463palmar
piaffer15104443piaffer
puffer144610733puffer
quaffer2235133quaffer
radar61316723ra_dar
raff104933043raff__
raffia12287703raffia
raffias13237713raffias
raffle123910703raffle
raffler13339223raffler
raffs115017523raff_s
rafter94517583rafter
safari91110223sa_fari
safer84721813sa_fer
saggar84010853saggar
sambar103914163sambar
sangar73617683sangar
sansar63613393sansar
sardar73013173sardar
sarsar63011843sarsar
shofar1236303shofar
sofar86115493_sofar
staffer13299093staffer
suffari1345503suffari
suffer124314513suffer
taffarel1442563taffarel
taffia12286903taffia
taffias13377413taffias
taffy145110823taff_y
tafia84215493tafia_
tafias93111963tafias
talar56225383ta_lar
tartar63214753tartar
tatar56122063ta_tar
valvar12388653valvar
wafer114417643wa_fer
waff134228043waff__
waffed16459793waffed
waffie15338563waffie
waffle15369183waffle
waffler16377783waffler
waffly18305433waffly
waffs146315473waff_s
wafter124114613wafter
warfare1336733warfare
yaff135324263yaff__
yaffed16457323yaffed
yaffs145311123yaff_s
zaffres22324993zaffres
zaftig1933253zaftig
zaikai1943713zaikai
zamia165115213zamia_
zamias174212923zamias
zander163417113zander
zanier154314713zanier
zanza1378703zanza_
zanzas1487053zanzas
zapper193414023zapper
zarf166929123zarf__
zarfs174713623zarf_s

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161717.03316026.7
3Display Results1711710.0762250.0
 (SQL Overall)1786911717.24924650.4
 
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.