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

327 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
prefire12401281(None) 
prefile123413181prefile
prefired144310751prefired
prefires134313281prefires
prewire124311141prewire
refire95419471_refire
precipe133012122precipe
precise113518172precise
precure11312552precure
predive13511082predive
preface14510922preface
prefade1339012prefade
prefer113813202prefer_
prefers123713332prefers
prefigure1544042prefigure
prefiled143310572prefiled
prefiles133113442prefiles
prefix18356852prefi_x
prefixed21357702prefixed
prefixes20389232prefixes
preform1439612preform
prelife1279942prelife
premie103617992premi_e
premier113515632premier
premiere12249232premiere
premise113818552premise
prepare111913622prepare
preside10715612preside
previse123713792previse
prewired14358472prewired
prewires133811012prewires
profile123211152profile
refile95122372_refile
refine95225692_refine
refired115116992_refired
refires104820312_refires
rehire95415862_rehire
retire64927012_retire
rewire95421412_rewire
surefire1145212surefire
afire86215913__afire
arenite71017713arenite
armoire938133armoire
balefire1344663balefire
beefier12329093beefier
before11410153_before
bemire103312803_bemire
bonfire1287063bonfire
brevier1237763brevier
crepier1139743crepier
crevice1436153crevice
defier105118653_defier
defile105216663_defile
define104718143_define
desire7415303_desire
drumfire1442543drumfire
eremite9312833eremite
fire76245593___fire
foxfire2042563foxfire
frere85617723fre__re
grecize1935663grecize
greige847203gre_ige
gunfire1134743gunfire
kefir12457913_kefir_
kefirs13396653_kefirs
misfire12229893misfire
olefine1038023olefine
oreide7311673ore_ide
orifice1246343orifice
outfire1049713outfire
pareira937533pare_ira
peerie83617893peeri_e
peise75825773p_e_ise
pelite84323003p_elite
penile82219603p_enile
perdie94718513perdi_e
perdure10379623perdure
pere66450263p_e__re
perfidy1635273perfidy
perforce1544963perforce
perform1439283perform
perfume1446503perfume
perfuse1247663perfuse
perjure16327963perjure
perkier133813123perkier
perlite9317323perlite
perspire1246663perspire
petite84320653p_etite
piefort1249533piefort
pismire1135353pismire
poetise9314043poetise
poetize18310773poetize
postfire1346273postfire
praecipe1444633praecipe
prairie938333pr_airie
praise84419413pr_aise
praline93019743praline
prearm104512353pre_arm
preaver121011613preaver
prebade12310283prebade
prebake1539093prebake
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebirth1543463prebirth
precede1239653precede
precipes143212213precipes
precis103416703preci_s
precised133213413precised
preciser123411663preciser
precises123218333precises
precited133013813precited
precode12311853precode
precured1339993precured
precures12312903precures
predate10616893predate
predefine1546173predefine
predial103815413predial
predict12315323predict
predried12309573predried
predries112714383predries
predry1237873pre_dry
pree67044733pre___e
preeing103817673preeing
preemie11310563preemie
preener93114833preener
prefab1336243pref_ab
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefaded1537823prefaded
prefades1439533prefades
prefect141011073prefect
preferred1555003preferred
preferrer1443893preferrer
prefight1746393prefight
prefigured1743313prefigured
prefigures1643903prefigures
prefilled1535513prefilled
prefiring1559073prefiring
prefixal2044543prefixal
preflame1545913preflame
preformed17176203preformed
preforms1537403preforms
prefroze2264673prefroze
prefund1335733prefund
pregame1239553pregame
preguide1255423preguide
prelate9519693prelate
prelim10311423preli_m
prelims1139823prelims
prelives13310383prelives
prelude1038013prelude
premade12311443premade
premiered14237093premiered
premieres13288233premieres
premiers122911653premiers
premies113823063premies
premised133013193premised
premises123018273premises
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixed20338013premixed
premixes193110083premixes
premixt183510663premixt
premorse1237553premorse
premune1138933premune
prename11412643prename
prentice121012353prentice
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepave14228873prepave
prepill1147583prepill
preppie1058093preppie
preppier1156643preppier
prepreg12165963pre_preg
preprice1488873preprice
prepuce1337833prepuce
prerace11414123prerace
prerinse1038633prerinse
preriot9316413preriot
presage10312293presage
presale9416353presale
prescore124812373prescore
prese75228383pre__se
preserve13108803preserve
presided12410553presided
presider11410423presider
presides11414913presides
presift12312223presift
preslice1258623preslice
presort95219543presort
presser93717623presser
pressure1039773pressure
prester93519623prester
prestige11310733prestige
prestore104217353prestore
presume11310303presume
pretape113511623pretape
preterm11310163preterm
pretor8315753pretor_
pretors9316813pretors
pretrim11310783pretrim
prettier1069043prettier
pretype14387483pretype
preunite1039573preunite
preverb14317063preverb
preview1536473preview
prevised143611073prevised
previses133814283previses
prevue1179163pre_vue
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
prework164210913prework
preworn124711223preworn
prexies163415003prexies
preyer114413733preyer_
preyers124412363preyers
preying133114553preying
price93725413pr__ice
pricier113313113pricier
pride84724733pr__ide
prier75027763pr__ier
prime96525603pr__ime
primine113214823primine
prise74632613pr__ise
prisere9310943prisere
privier122910453privier
prize164718943pr__ize
procure1138573procure
profane122111863profane
proffer15126933proffer
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273profi_t
profited14279973profited
profiter132710203profiter
profits122911243profits
profuse1237153profuse
proline92321593proline
promine112819443promine
promise113415843promise
propine113020213propine
prosier93817483prosier
provide1339853provide
puerile9310093puerile
puffier1547973puffier
purifier1338573purifier
putrefier1443123putrefier
rarefier1135353rarefier
rebore86625653_rebore
recipe103414893_recipe
recite83625113_recite
rediae74221993_rediae
reefier102912553reefier
reface113616353_reface
refer84822143_refer_
referee101615753_referee
refers93921083_refers
refigure1254693_refigure
refiled114318653_refiled
refiles104122423_refiles
refill94514053_refill
refilm114311403_refilm
refind104717073_refind
refined114720003_refined
refiner105316913_refiner
refines105426343_refines
refit84230063_refi_t
refits94017653_refits
refix155212483_refi_x
refixed183611153_refixed
refixes174813173_refixes
reforge11259033_reforge
reform11312713_reform
refried113513873_refried
refries104419733_refries
refry114412463_ref_ry
refuge105312613_refuge
refuse94817513_refuse
refute95515703_refute
regime95313943_regime
regive104814323_regive
rehired115013153_rehired
rehires105016113_rehires
reifier103414523_reifier
reive85522943_re_ive
relier65826183_relier
reline65434353_reline
relive95120783_relive
remise84221953_remise
repine85627813_repine
require16148653_require
rerise64325633_rerise
reside74224933_reside
resile64627673_resile
resite64128453_resite
resize154117723_resize
respire9411543_respire
retie55735303_reti_e
retile65929673_retile
retime85321803_retime
retine66237333_retine
retired84620143_retired
retiree75019083_retiree
retirer74715013_retirer
retires74726213_retires
retore67630773_retore
revere94621253_revere
revile94921613_revile
revise94019743_revise
revive124914823_revive
rewired115413283_rewired
rewires104717113_rewires
rewore938030163_rewore
rexine134719443_rexine
rimfire1243793rimfire
spitfire1343053spitfire
unretire846963unretire
ureide7310363ure_ide
venire93513693_venire

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273277.26318453.4
3Display Results3273270.1262595.2
 (SQL Overall)1786913277.79522923.8
 
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.