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

260 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
prefixes2038923(None) 
prefiles133113441prefiles
prefires134313281prefires
prefixed21357701prefixed
premixes193110081premixes
refixes174813171_refixes
phenixes2035642phenixes
precipes143212212precipes
precises123218332precises
prefaces15311062prefaces
prefades1439532prefades
prefile123413182prefile_
prefiled143310572prefiled
prefire124012812prefire_
prefired144310752prefired
prefix18356852prefix__
prefixal2044542prefixal
prelives13310382prelives
premies113823062premi_es
premises123018272premises
premixed20338012premixed
presides11414912presides
previses133814282previses
prewires133811012prewires
prexes154915952pre__xes
prexies163415002prexi_es
profiles133211232profiles
refiles104122422_refiles
refines105426342_refines
refires104820312_refires
refixed183611152_refixed
remixes164313872_remixes
affixes2035503_affixes
antefixes1944333antefixes
arenites8917103arenites
bemixes18338653_bemixes
brewises1337213brewises
cervixes2054603cervixes
crevices1536713crevices
defies104624053_defi_es
defiles114016843_defiles
defines114118683_defines
eremites10312603eremites
fixes154723593___fixes
grecizes2035683grecizes
greiges937733gre_iges
helixes1739133_helixes
infixes17238133_infixes
olefines1137323olefines
oreides8312023ore_ides
orifices1346483orifices
panmixes1934913panmixes
peeries93623023peeri_es
peises84125043p_e_ises
pelites93821993p_elites
penises9318193p_enises
perfidies1546603perfidies
perfumes1555893perfumes
perfuses1358663perfuses
perlites10316363perlites
perries93226603perri_es
petites93820203p_etites
phoenixes2143393phoenixes
pieties9419223pieti_es
pixes144323173p___ixes
plexes155313543ple__xes
poesies93217403poesi_es
poetises10313953poetises
poetizes19310253poetizes
postfixes2164473postfixes
praecipes1544853praecipes
praises94121103pr_aises
pralines102217723pralines
praxes156215183pr__axes
praxises1739063praxises
preaches153214893preaches
prebakes1639013prebakes
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
precedes13310713precedes
precious12310593precious
precipe133012123precipe_
precis103416703preci__s
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
precited133013813precited
precodes13711573precodes
precures12312903precures
predates11615813predates
predefines1645433predefines
predicts1339613predicts
predigest1357633predigest
predive13511083predive_
predries112714383predries
preemies12512193preemies
prees75937173pre___es
prefabs1435163pref_abs
preface14510923preface_
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefade1339013prefade_
prefaded1537823prefaded
prefects1598133prefects
prefer113813203pref__er
prefers123713333pref_ers
prefight1746393prefight
prefigures1643903prefigures
prefilled1535513prefilled
prefixing2246783prefixing
prefixion2144113prefixion
prefixions2243873prefixions
prefocus1544743prefocus
preforms1537403preforms
prefunds1454693prefunds
pregames1339003pregames
preguides1344863preguides
prelates10418573prelates
prelife1279943prelife_
prelims1139823preli_ms
preludes1137833preludes
premie103617993premi_e_
premier113515633premi_er
premieres13288233premieres
premiers122911653premiers
premise113818553premise_
premised133013193premised
premiss113513813premi_ss
premisses13288763premisses
premiums1437533premiums
premix173710333premix__
premixt183510663premix_t
prenames12311643prenames
prentices131111903prentices
prepares122014163prepares
prepaves15189193prepaves
preppies1149693preppies
preprices1569263preprices
prepubes1436053prepubes
prepuces1438583prepuces
prerinse1038633prerinse
prerinses1138813prerinses
presages11312203presages
presales10315263presales
preside10715613preside_
presided12410553presided
presider11410423presider
presiders1248213presiders
presifts1366593presifts
preslices1338213preslices
presses93523153pre_sses
prestiges12310593prestiges
presumes1239843presumes
pretapes122811533pretapes
pretexts1735603pretexts
pretties10615133pretties
pretypes15337263pretypes
preunites1138933preunites
preview1536473previ_ew
previews1634513previews
previous1337823previous
previse123713793previse_
prevised143611073prevised
prevues1239263pre_vues
prewire124311143prewire_
prewired14358473prewired
prezes173614693pre__zes
prices104524543pr__ices
prides94324183pr__ides
pries74339533pr__i_es
primes104225263pr__imes
primines123013703primines
prises84133173pr__ises
privies122414263privi_es
prizes173819813pr__izes
profanes132311573profanes
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profilers14236293profilers
profited14279973profited
profiter132710203profiter
profiters14228313profiters
profits122911243profi_ts
prolines102619693prolines
promines123018803promines
promises122916763promises
propines122618933propines
provides1439883provides
proxies163014933proxi_es
purifies13311923purifi_es
putrefies1444663putrefi_es
pyrexes19305843pyre__xes
radixes15259343_radixes
rarefies1138993rarefi_es
reaffixes2243023_reaffixes
recipes113314463_recipes
recites93524583_recites
redoxes15310883_redoxes
refaces123216743_refaces
refile95122373_refile_
refiled114318653_refiled
refills103711423_refills
refilms12347503_refilms
refinds114512123_refinds
refine95225693_refine_
refined114720003_refined
refiner105316913_refiner
refiners114713313_refiners
refire95419473_refire_
refired115116993_refired
refits94017653_refi_ts
refix155212483_refix__
reflexes1865933_reflexes
reflies104418533_reflies
refluxes1855183_refluxes
refries104419733_refries
refuges115413373_refuges
refuses104918553_refuses
refutes104515733_refutes
regimes104514743_regimes
regives115014213_regives
rehires105016113_rehires
reifies104218283_reifies
reives95723043_re_ives
relaxes143215323_relaxes
relies65036423_reli_es
relines75331323_relines
relives104619443_relives
remiges103015473_remiges
remises93423483_remises
remixed173510743_remixed
repines94927383_repines
rerises73525883_rerises
resides84523283_resides
resiles74026543_resiles
resites74027793_resites
resizes164216843_resizes
retaxes143615093_retaxes
reties65436193_reti_es
retiles74426993_retiles
retimes95020173_retimes
retines75134673_retines
retires74726213_retires
reviles104421353_reviles
revises104220533_revises
revives134715543_revives
rewaxes173911333_rewaxes
rewires104717113_rewires
rexes124526953_re__xes
rexines144719153_rexines
subfixes20207493subfixes
suffixes21196353suffixes
superfixes2246823superfixes
unfixes17238113_unfixes
ureides8311103ure_ides
vernixes1836053vernixes

Search took 10 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622609.04616157.6
3Display Results2602600.326797.5
 (SQL Overall)1786912609.79518243.1
 
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.