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

164 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
premixt18351066(None) 
premix173710331premix_
remixt155014851_remixt
bemixt174510362_bemixt
permit10321682permi_t
predict12315322predict
prefix18356852prefix_
premeet11615152premeet
premie103617992premi_e
premier113515632premier
premies113823062premies
premise113818552premise
premiss113513812premiss
premium13310362premium
premixed20338012premixed
premixes193110082premixes
premolt11312072premolt
preriot9316412preriot
presift12312222presift
pretext1639662pretext
remint85329982_remint
remit75737222_remi_t
remix145916552_remix_
admixt1637333_admixt
bemist105216963_bemist
bemix165011453_bemix_
chemist143615003chemist
commixt20357623commixt
credit9315193credi_t
cremini11229063cremini
demit84832303_demi_t
emit65438423__emi_t
eremite9312833eremite
gremial1039153gremial
hermit11519443hermi_t
mixt136831923___mixt
palmist112814343palmist
peewit111110903peewi_t
permian112612283permian
perming123416093perming
permits11314003permits
persist9315853persist
petit74332653p_eti_t
pewit104622793p_ewi_t
phenix1837133phenix_
pietist9414033pietist
plenist9314333plenist
polemist12412363polemist
preact103220393pre_act
preadmit1346813preadmi_t
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebirth1543463prebirth
prebuilt1247033prebuilt
precast11314853precast
precent113520263precent
precept133112513precept
precinct1459423precinct
precipe133012123precipe
precis103416703preci_s
precise113518173precise
precut102016533pre_cut
predial103815413predial
predicts1339613predicts
predive13511083predive
preedit10512463preedit
preeing103817673preeing
preemie11310563preemi_e
preemies12512193preemies
preempt1337723preempt
preexist1747963preexist
prefect141011073prefect
prefight1746393prefight
prefile123413183prefile
prefire124012813prefire
prefixal2044543prefixal
prefixed21357703prefixed
prefixes20389233prefixes
preheat12413893preheat
prelect111013833prelect
prelife1279943prelife
prelim10311423preli_m
prelimit1259123prelimit
prelims1139823prelims
premade12311443premade
preman104117453prem_an
premeal11310523premeal
premed114617763prem_ed
premeds12389593premeds
premen105017803prem_en
premiere12249233premiere
premiers122911653premiers
premised133013193premised
premises123018273premises
premiums1437533premiums
premixing2157803premixing
premold1247863premold
premune1138933premune
prepill1147583prepill
preprint12314183preprint
present94022733present
preset84430983pre_set
preside10715613preside
presifts1366593presifts
presort95219543presort
prest75736353pre__st
pretax152310193pretax_
pretest9517633pretest
pretexts1735603pretexts
prevent124016553prevent
preview1536473preview
previse123713793previse
previsit13410073previsit
prewire124311143prewire
prex135722973pre__x_
prexies163415003prexies
prexy174611583pre__xy
preying133114553preying
primi95017403primi__
primine113214823primine
priming123417373priming
print74837463pr__int
probit103218353probi_t
proemial1249183proemial
profit113016273profi_t
prolix1538683prolix_
promine112819443promine
promise113415843promise
prompt12313013prom_pt
prosit85124593prosi_t
protist9320223protist
pyemia1337553pyemi_a
pyemias1436803pyemias
pyemic1537893pyemi_c
recit75235103_reci_t
redipt94116743_redipt
reemit8717223reemi_t
refit84230063_refi_t
refix155212483_refix_
regilt71217493_regilt
relict83623903_relict
relist64628413_relist
relit55340683_reli_t
remeet86325473_remeet
remelt85123123_remelt
remet74843723_rem_et
remex146315793_remex_
remind94819793_remind
remints95117293_remints
remise84221953_remise
remiss84216353_remiss
remits85622943_remits
remixed173510743_remixed
remixes164313873_remixes
resift94017723_resift
resist64524533_resist
resit54241043_resi_t
retint65633443_retint
unmixt15378703_unmixt
uremia82910893uremi_a
uremias9249503uremias
uremic103410513uremi_c

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 Limit1340271646.11021935.7
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.57927160.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.