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

238 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
primero1136892(None) 
primer105118681primer_
primeros12336881primeros
primers114215671primers
pricer103918292pricer_
pricers113915062pricers
prier75027762pri_er_
priers84521192pri_ers
primary1437702primary
prime96525602prime__
primed115118912prime_d
primely1457722primely
primes104225262prime_s
primmer134310162primmer_
primo95017912prim__o
prisere9310942prisere
prizer174714882prizer_
prizers183911842prizers
rimer75429242_rimer_
rimers84522552_rimers
trimer85717152trimer_
trimers94615142trimers
aimer75926823_aimer_
aimers84621913_aimers
arider74717743arider_
armer76924443ar_mer_
armers85520273ar_mers
armigero1142693armigero
bracero11428743bracero
briber104714053briber_
bribers114111503bribers
bribery14426493bribery
brier74527403bri_er_
briers85319733bri_ers
briery114510773bri_ery
brimmer13348803brimmer_
brimmers14287073brimmers
briner84519043briner_
briners94315633briners
chimer135517203chimer_
chimera14389273chimera
chimere144010633chimere
chimers144515143chimers
cicero1048503_cicero
crier74724463cri_er_
criers83918583cri_ers
crime94822693crime__
crimes105521583crime_s
crimmer133310773crimmer_
crimmers14298543crimmers
crimper136510423crimper_
crimpers14318933crimpers
dimer85625603_dimer_
dimers94321093_dimers
dinero75612643_dinero
drier64423963dri_er_
driers74516733dri_ers
driver104714493driver_
drivers114412793drivers
epimer10109153epimer_
epimere1186983epimere
epimers11109493epimers
erigeron944463erigeron
firmer114712443firmer_
firmers124711443firmers
framer114817443framer_
framers125113823framers
frier85225843fri_er_
friers94718933fri_ers
frizer184011283frizer_
frizers19329553frizers
grime85021323grime__
grimed104714093grime_d
grimes94619033grime_s
grimier103210433grimier_
grimmer123510093grimmer_
griper94114613griper_
gripers104011463gripers
krimmer15376873krimmer_
krimmers16315673krimmers
lorimer937753lorimer_
lorimers1036613lorimers
maimer104514593maimer_
maimers113813043maimers
mimeo96018683_mime_o
mimer94825763_mimer_
mimers105520183_mimers
ormer75218373or_mer_
ormers84316143or_mers
palmer105816543palmer_
palmers113513623palmers
pampero13328093pampero
periderm1346803periderm
perimetry1646503perimetry
picaro10311323p_icaro
pier66035293p_i_er_
piers75926333p_i_ers
piker115622843p_iker_
pikers124717393p_ikers
pimento1157223p_imento
pinery115214293p_inery
piper96523193p_iper_
pipers104318663p_ipers
plier75221283pli_er_
pliers84715153pli_ers
poiser84217243poiser_
poisers94214433poisers
pomelo10238663p_omelo
praiser93413943praiser_
praisers103410833praisers
prater84825353prater_
praters94921653praters
prayer114815293prayer_
prayers124212853prayers
prefer113813203prefer_
prefers123713333prefers
premeal11310523premeal
premed114617763preme_d
premeds12389593premeds
premeet11615153premeet
premen105017803preme_n
premier113515633premier_
premiere12249233premiere
premiers122911653premiers
preterm11310163preterm
preverb14317063preverb
preyer114413733preyer_
preyers124412363preyers
price93725413price__
priced115018883price_d
prices104524543price_s
pricey134412633price_y
pricier113313113pricier_
pricker154013413pricker_
prickers163710673prickers
pride84724733pride__
prided103618033pride_d
prides94324183pride_s
pried84426863pri_e_d
pries74339533pri_e_s
priest84125423pri_est
priggery1543993priggery
prim85132203prim___
prima95019343prim__a
primacy1635603primacy
primage12169143primage
primal104014623prim_al
primas104418103prim_as
primate111516283primate
primavera1642403primavera
primeval1544103primeval
primi95017403prim__i
primine113214823primine
priming123417373priming
primly13439623prim_ly
primmed14388853primmed
primmest14226693primmest
primness1276763primness
primos104514423prim_os
primp115615923prim__p
primped14479153primped
primps124711823prim_ps
primrose1244503prim_rose
prims95425933prim__s
primsie1137543primsie
primula1145713primula
primus103712173prim_us
prinker133412743prinker_
prinkers143010383prinkers
printer93917303printer_
printers103214903printers
printery13318433printery
prior74316173pri_or_
priors83914483pri_ors
priory114110263pri_ory
prise74632613prise__
prised94322203prise_d
priseres10310823priseres
prises84133173prise_s
privet113821343prive_t
privets122910053privets
privier122910453privier_
prize164718943prize__
prized184415393prize_d
prizes173819813prize_s
prober104516073prober_
probers113514583probers
promo95620003prom__o
proper104319953proper_
propers113619033propers
proser84223463proser_
prosers94219643prosers
prover113819723prover_
proverb14378213proverb
provers123817793provers
prower114218123prower_
prudery1335243prudery
pruner83413453pruner_
pruners93710723pruners
pryer104415313pr_yer_
pryers115012243pr_yers
pumelo10257113p_umelo
pummelo13284233pummelo
rezero1578873_rezero
ricer74726613_ricer_
ricers84120993_ricers
rider65231303_rider_
riders74123903_riders
rifer84721983_rifer_
rime65138883_rime__
rimed84826373_rime_d
rimes75634543_rime_s
rimier83916273_rimier_
rimmer103516033_rimmer_
rimmers113812883_rimmers
riper74328403_riper_
riser55431053_riser_
risers64624783_risers
river85731693_river_
rivers94626543_rivers
romeo73719703_rome_o
sprier84119063spri_er_
timer75626043_timer_
timers84420993_timers
trier54328533tri_er_
triers64321523tri_ers
trimeric1246943trimeric
trimerous1146483trimerous
trimmer113610833trimmer_
trimmers12288913trimmers
triter65120593triter_
upriser9218763upriser_
uprisers10206773uprisers
upriver12196933upriver_
uprivers13215563uprivers
wrier84521753wri_er_
writer94416513writer_
writers105513493writers

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 Limit1340272386.70319995.1
3Display Results2382380.0763131.6
 (SQL Overall)1786912387.18524870.0
 
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.