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

161 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
prerinse103863(None) 
prerinsed1246321prerinsed
prerinses1138811prerinses
precise113518172preci_se
premise113818552premi_se
prepense12238942prepense
pretense10199822pretense
previse123713792previ_se
pterins9812992pterins_
rerise64325632_reri_se
cerise84822043_ceri_se
cretins93216423cretins_
eserine7415903eserin_e
eserines8413743eserines
eternise8119663eternise
ferine96422583_ferin_e
peerie83617893peeri__e
peeries93623023peeries_
peering103520353peerin_g
peins76128063p_e_ins_
peise75825773p_e_i_se
pekins121812233p_ekins_
pelerine10313013pelerin_e
pelerines11311843pelerines
pelisse967063p_elisse
peregrine1247043peregrin_e
peregrines1346513peregrines
peregrins1246963peregrins_
perfuse1247663p_erfuse
perigee101113393p_erigee
perils84121853p_erils_
perinea9313033p_erinea
perique1837523p_erique
peris75537073p_eri_s_
perish114619063p_eri_sh
perries93226603perries_
perrons93115483perrons_
perse75429523p_er__se
peruse84016843p_er_use
piperine122011833piperin_e
piperines131610693piperines
poetise9314043poeti_se
praise84419413pr_ai_se
praline93019743pralin_e
pralines102217723pralines
prebids12399883prebids_
prebind123810643prebin_d
prebinds13357733prebinds
prechose15129773prechose
precieuse1344613precieuse
precinct1459423precinct
precipe133012123preci_pe
precipes143212213precipes
precis103416703preci_s_
precised133213413preci_sed
preciser123411663preci_ser
precises123218333preci_ses
precrease1345233precrease
predinner1245133predinner
predive13511083predi_ve
predries112714383predries_
preeing103817673preein_g
preens85020113pre_ens_
prefile123413183prefi_le
prefiles133113443prefiles
prefire124012813prefi_re
prefires134313283prefires
prefixes20389233prefixes
preinsert1148573pre_insert
prelife1279943preli_fe
prelims1139823prelims_
prelives13310383prelives
premie103617993premi__e
premiere12249233premiere
premies113823063premies_
premised133013193premi_sed
premises123018273premi_ses
premiss113513813premi_ss
premisses13288763premisses
premixes193110083premixes
premorse1237553premorse
premune1138933premun_e
preprice1488873prepri_ce
preprices1569263preprices
preprint12314183preprin_t
preprinted1546543preprinted
preprints1347473preprints
prerace11414123prer_ace
prerenal1049083prerenal
prerinsing1347643prerinsing
preriot9316413preri_ot
prese75228383pre___se
presence122213513presence
preside10715613presi_de
presides11414913presides
pretence122312123pretence
pretenses112210593pretenses
pretrains11410143pretrains_
pretrims1238983pretrims_
preunite1039573preunite
prevised143611073previ_sed
previses133814283previ_ses
prewire124311143prewi_re
prewires133811013prewires
prexies163415003prexies_
preying133114553preyin_g
primine113214823primin_e
primines123013703primines
prince104114763p__rince
prise74632613p__ri_se
proline92321593prolin_e
prolines102619693prolines
promine112819443promin_e
promines123018803promines
promise113415843promi_se
propense122410103propense
propine113020213propin_e
propines122618933propines
province1546923province
pruinose1044853pr_uinose
prurience1344763prurience
pterin81014153pterin__
puerile9310093pueri_le
purine85321893p_urin_e
purines94420763p_urines
purins83722653p_urins_
refine95225693_refin_e
refines105426343_refines
reginae84713453_reginae
rehinge1148503_rehinge
reins56234563_re_ins_
reline65434353_relin_e
relines75331323_relines
remise84221953_remi_se
renins64526453_renins_
repine85627813_repin_e
repines94927383_repines
repins84924313_repins_
reprise92715043_repri_se
reraise7316313_reraise
rerigs74014793_rerigs_
rerisen73613643_reri_sen
rerises73525883_reri_ses
rerose63320843_rer_ose
reruns66413743_reruns_
resins64528773_resins_
retinae75517333_retinae
retine66237333_retin_e
retines75134673_retines
retinue75414843_retinue
revise94019743_revi_se
rewins95020823_rewins_
rexine134719443_rexin_e
rexines144719153_rexines
rinse54820973___rinse
serine65432673_serin_e
serines74229543_serines
serins64029673_serins_
terrine72517573terrin_e
terrines82117553terrines
uterine7315193uterin_e

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621617.42319690.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.88922650.7
 
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.