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

139 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
zaffirs2237566(None) 
kaffirs17325551kaffirs
zaffars22325231zaffars
zaffers22386771zaffers
zaffir21395511zaffir_
affairs1334162_affairs
affirm1435522_affirm
affirms1534382_affirms
baffies153612942baffies
gaffers14428712gaffers
haffits1636192haffits
kaffir16345302kaffir_
kafirs13306982ka_firs
maffias15327282maffias
maftirs1236042maftirs
raffias13237712raffias
taffias13377412taffias
taffies133012692taffies
waffies163611442waffies
zaffar21385042zaffar_
zaffer21397152zaffer_
zaffre21354662zaff_re
zaffres22324992zaffres
afars85716513_a_fars
affair1234353_affair_
affaire1344463_affaire
affaires1444303_affaires
affine12310503_affine
affines1339483_affines
affix1836003_affi_x
affixers2143293_affixers
affixes2035503_affixes
afford1346493_afford
affords1435023_affords
afire86215913_a_fire
afrits9311903_afrits
afters94717073_afters
airs46447423_a__irs
amirs75924923_a_mirs
baffing164011603baffing
bafflers16356593bafflers
baffles153710683baffles
baffs134718053baff__s
biffies152710853biffies
biffins15358533biffins
boffins15329073boffins
buffers153310793buffers
caffeins1645123caffeins
caffs135417373caff__s
chaffers19378003chaffers
coffers154112693coffers
coffins153110193coffins
daffier1457833daffier
daffiest1537843daffiest
daffily1735133daffily
daffing15369733daffing
daffs125116423daff__s
differs14339973differs
doffers14359853doffers
duffers143410093duffers
fairs85825443__fairs
fakirs13468083fa_kirs
fanfics1535173fanfics
faqirs18456033fa_qirs
faquirs1943863faquirs
firs76637713___firs
flirs85518933__flirs
gaffer134310133gaffer_
gaffes134811103gaff_es
gaffing15379733gaffing
gaffs124914653gaff__s
gambirs12359083gambirs
gauffers1563833gauffers
goffers14409213goffers
haffets1636053haffets
haffit1538533haffi_t
hafters134614333hafters
hairs86225173ha__irs
jiffies20327473jiffies
kafir12488903ka_fir_
kefirs13396653_kefirs
lairs55425873la__irs
maffia14327203maffi_a
maffick2143523maffick
mafficks2243173mafficks
mafias113913573ma_fias
maftir1136493maftir_
mairs76228303ma__irs
muffins15308343muffins
nadirs7109003na_dirs
naffing14359033naffing
naffs116213963naff__s
niffers13287363niffers
offers12349963_offers
pairs75325833pa__irs
piaffers16114203piaffers
puffers15349203puffers
puffins15278913puffins
quaffers2333963quaffers
raffia12287703raffi_a
raffish1658843raffish
rafflers14317363rafflers
raffles133611843raffles
raffs115017523raff__s
rafters103715633rafters
reaffirm1642483reaffirm
reaffirms1741943reaffirms
sabirs85414633sa_birs
safaris101110663safaris
santirs7312963santirs
soffits1335093soffits
staffers14247083staffers
suffers133113543suffers
taffia12286903taffi_a
tafias93111963ta_fias
tapirs84113173ta_pirs
tiffins13327983tiffins
toffies133210213toffies
traffics1644183traffics
vairs85019133va__irs
wafers124316143wa_fers
waffie15338563waffi_e
waffing173710243waffing
wafflers17306323wafflers
waffles16329983waffles
waffs146315473waff__s
wafters134112813wafters
wairs86424063wa__irs
yaffing17337823yaffing
yaffs145311123yaff__s
zaftig1933253zafti_g
zaire14311993za__ire
zaires1539703za__ires
zamias174212923za_mias
zanders173015793zanders
zanies153219673za_nies
zappers203911633zappers
zarfs174713623zarf__s
zayins18409713za_yins

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271395.72023431.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.17228951.9
 
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.