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

118 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
affixer203391(None) 
affixed2134121affixed
affixers2143291affixers
affixes2035501affixes
affine12310502affine_
affined1436412affined
affines1339482affines
affirmer1643082affirmer
affix1836002affix__
affixal2043762affixal
daffier1457832daffi_er
fixer154717832__fixer
iffier1236762iffi_er
officer1534212officer
abider95314463a_bider
achier113914263achi_er
acrider1038623acrider
admirer1035523admirer
admixed1833733admixed
admixes1765963admixes
adviser11135783adviser
aerier64823153aeri_er
affair1234353aff_air
affaire1344463affaire_
affaires1444303affaires
affecter1644523affecter
affiant1348433affiant
affiche1844313affiche
affiches1945233affiches
affinal1336443affinal
affinely1743863affinely
affirm1435523affi_rm
affirmed1743213affirmed
affirmers1742563affirmers
affirms1534383affirms
affixial2143593affixial
affixing2264333affixing
affixment2443883affixment
affixture2251813affixture
afflicter1742823afflicter
affluxes2142533affluxes
affrayer1742693affrayer
afire86215913a_fire_
after85719793a_f_ter
aider65431133a__ider
aimer75926823a__imer
airer54927893a__irer
airier64619363airi_er
aiver85725163a__iver
aliner65621983a_liner
aquifer1934883aquifer
aquiver1934753aquiver
arbiter939933arbiter
arider74717743a_rider
armiger1036253armiger
arriver10117793arriver
artier63419733arti_er
ashier94714833ashi_er
aspirer967903aspirer
avoider1155813avoider
awaiter1057443awaiter
baffies153612943baffi_es
baffler15418113baff_ler
buffier1568403buffi_er
chaffier1935473chaffi_er
defier105118653defi_er
defiler113911883defiler
definer114413773definer
draffier1574323draffi_er
effacer15255413effacer
fainer94717243_fainer
fairer95212063_fairer
fiber104921133__fiber
fifer115519973__fifer
filer85433003__filer
finer85431563__finer
firer811229253__firer
fiver116024943__fiver
fixed165416953__fixed
fixers165112983__fixers
fixes154723593__fixes
flier86023403_fli_er
foxier163910033_foxier
frier85225843_fri_er
frizer184011283_frizer
gaffer134310133gaff__er
huffier1637493huffi_er
infixed18206563infixed
infixes17238133infixes
kaffir16345303kaffi__r
kaffiyeh2461923kaffiyeh
mafficker2342253mafficker
miffier1537023miffi_er
mixer145017643__mixer
offer114311383off__er
offerer1335543offerer
office1435693office_
officers1643803officers
offices1536243offices
puffier1547973puffi_er
raffler13339223raff_ler
reaffixed2342293reaffixed
reaffixes2243023reaffixes
refiner105316913refiner
refixed183611153refixed
refixes174813173refixes
sufficer16225823sufficer
suffixed22214343suffixed
suffixes21196353suffixes
taffies133012693taffi_es
unfixed18218563unfixed
unfixes17238113unfixes
waffie15338563waffi_e_
waffies163611443waffi_es
waffler16377783waff_ler
wafflier1733953wafflier
zaffer21397153zaff__er
zaffir21395513zaffi__r

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 Limit1340271185.90622693.4
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.35828104.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.