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

246 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
prefix1835685(None) 
premix173710331premix
refix155212481_refix
phenix1837132phenix
prebid113512842prebid
precis103416702precis
prefab1336242prefab
prefer113813202prefer
prefile123413182prefile
prefire124012812prefire
prefixal2044542prefixal
prefixed21357692prefixed
prefixes20389232prefixes
prelim10311422prelim
premie103617992premie
premixt183510662premixt
pretax152310192pretax
prex135722972pre__x
profit113016272profit
prolix1538682prolix
refit84230062_refit
remix145916552_remix
affix1836003_affix
antefix1745053antefix
areic73219393are_ic
barefit1249723barefit
befit105222663_befit
bemix165011453_bemix
brewis11469983brewis
cervix1865163cervix
credit9315193credit
cretic102816283cretic
cretin82917913cretin
defi86321493_defi_
defis96717503_defis
fix136236103___fix
helix154413013_helix
infix15337763_infix
ireful948713ireful
irenic8311103irenic
kefir12457913_kefir
olefin937583olefin
paresis93315093paresis
paretic113016673paretic
peerie83617893peerie
peewit111110903peewit
pein65834943p_e_in
pekin111514423p_ekin
penis75129323p_enis
perdie94718513perdie
pereia85217983pereia
perfidy1635263perfidy
peri65636973p_eri_
peril75425953p_eril
peris75537073p_eris
permit10321683permit
pernio8513143pernio
petit74332653p_etit
pewit104622793p_ewit
phoenix1944353phoenix
phrenic1438773phrenic
pix126437933p___ix
plex137321373ple__x
poetic10416843poetic
postfix1944673postfix
praxis154012253praxis
preach133613923preach
preact103220393preact
preamp1238993preamp
prearm104512343prearm
prebids12399873prebids
prebill1138803prebill
prebind123810643prebind
preboil1148943preboil
prebuy1357423prebuy
precieux1943033precieux
precipe133012123precipe
precise113518173precise
precut102016533precut
predial103815413predial
predict12315323predict
predive13511083predive
predry1237863predry
pree67044733pre__e
preed85128113pre_ed
preedit10512453preedit
preeing103817673preeing
preemie11310563preemie
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefect141011073prefect
prefers123713333prefers
prefight1746393prefight
prefiled143310573prefiled
prefiles133113443prefiles
prefired144310753prefired
prefires134313283prefires
prefixing2246783prefixing
prefixion2144113prefixion
preform1439603preform
prefund1335733prefund
prelaw1139103prelaw
prelife1279943prelife
prelims1139823prelims
preman104117453preman
premed114617753premed
premen105017803premen
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premixed20338003premixed
premixes193110083premixes
preop94715873pre_op
preops104911933preops
prep86427673pre__p
prepaid12310133prepaid
prepay13310313prepay
prepill1147583prepill
preppie1058093preppie
preppy1235523preppy
preps96220693pre_ps
preriot9316413preriot
presa74319043pre_sa
prese75228383pre_se
preset84430983preset
preship1439793preship
preside10715613preside
presift12312223presift
press75425953pre_ss
prest75736353pre_st
presto84216203presto
prests84021263prests
pretext1639663pretext
pretor8315743pretor
pretrim11310773pretrim
pretty11510873pretty
prevail1238243prevail
preview1536473preview
previse123713793previse
prevue1179163prevue
prewar114712573prewar
prewire124311133prewire
prexes154915943prexes
prexies163415003prexies
prexy174611573pre_xy
prey96228483pre__y
preyed125313193preyed
preyer114413733preyer
preying133114553preying
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
prig75924873pr__ig
prim85132203pr__im
primi95017403primi_
probit103218353probit
prof96134663prof__
profile123211153profile
profits122911243profits
profs105120893prof_s
prosit85124593prosit
pterin81014153pterin
puffin141149003puffin
pyemia1337553pyemia
pyemic1537893pyemic
pyretic143210783pyretic
pyrex175211213pyre__x
pyrexia19225463pyrexia
pyrexic21235353pyrexic
radix134414593_radix
reaffix2042323_reaffix
rebid85121353_rebid
recit75235103_recit
redfin10310223_redfin
redia65524483_redia
redid74922393_redid
redip87816963_redip
redox134714233_redox
redux133811103_redux
ref66053293_ref__
refed93921923_refed
refel84920813_refel
refer84822143_refer
refile95122373_refile
refill94514053_refill
refilm114311403_refilm
refind104717073_refind
refine95225693_refine
refire95419473_refire
refits94017653_refits
refixed183611153_refixed
refixes174813173_refixes
reflex16359513_reflex
reflux16315413_reflux
refly113914563_refly
refry114412463_refry
refs75732243_ref_s
reft75141273_ref_t
rei35647253_re_i_
reif76937643_re_if
reifs84819093_reifs
reify114814973_reify
rein46040893_re_in
reis45343233_re_is
rejig133810123_rejig
relax124817803_relax
relic74623363_relic
relit55340683_relit
remex146315793_remex
remit75737223_remit
remixt155014853_remixt
renig64518913_renig
renin54830033_renin
reoil55321183_reoil
repin75324703_repin
rerig64018483_rerig
resid64124093_resid
resin54131053_resin
resit54241043_resit
retax124517973_retax
retia55326113_retia
retie55735303_retie
rewax155713923_rewax
rewin85623963_rewin
rex105740993_re__x
subfix1835073subfix
suffix1935233suffix
superfix2045463superfix
tref77030993tref__
trefah1235093trefah
trefoil1066063trefoil
trepid9310083trepid
trifid1039063trifid
unfix15429033_unfix
uredia73610063uredia
ureic74514463ure_ic
uremia82910893uremia
uremic103410513uremic
uretic82914353uretic
vernix1636633vernix

Search took 6 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.1231452772.4
2DLD Change Limit1127162465.61020092.0
3Display Results2462460.0763236.8
 (SQL Overall)1786912465.80930761.1
 
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.