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 “privater” 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
privater1315853(None) 
private121513261private_
privateer14134151privateer
privates131812371privates
prater84825352pr__ater
primate111516282primate_
primates121515932primates
printer93917302pri_nter
privateers15163062privateers
privately1744892privately
privatest14196732privatest
privier122910452priv_ier
riveter10208752_riveter
animater101512393animater
brighter1476663brighter
crater85026643cr__ater
critter94113033cri_tter
derivate12311203derivate_
derivates13310093derivates
dilater83515653_dilater
drifter11348703dri_fter
driveler1284693driveler
driver104714493driv__er
frater94520593fr__ater
frigate11311063frigate_
frigates12310933frigates
fritter103912773fri_tter
frivoler1443933frivoler
grater74625443gr__ater
greater84416493gr_eater
grifter113810493gri_fter
grimacer1363963grimacer
grister83915413gri_ster
gritter83913353gri_tter
irater65218353__irater
krater104014313kr__ater
orienter838313orienter
painter93814563pai_nter
pater74740723p___ater
perimeter1349563perimeter
peripter1278753peri_pter
pervader1444863pervader
philter12108213phi_lter
piaster93012883p_iaster
pilaster1038163p_ilaster
pinaster1037113p_inaster
pirate82322883p_irate_
pirated102515613p_irated
pirates93020333p_irates
pivoted1336513p_ivoted
placater1238013placater
plater84427693p__later
pleater93916333p_leater
plicate11314513plicate_
plicated13310643plicated
plighter1476623plighter
pointer93814933poi_nter
prate75135983pr__ate_
prated94924923pr__ated
praters94921653pr__aters
prates84633163pr__ates
prayer114815293pr__ayer
prealter1048863prealter
preaver121011613pr_eaver
predate10616893predate_
predated12513273predated
predates11615813predates
predator11310053predator
prefacer1537983prefacer
preheater1448913preheater
prelate9519693prelate_
prelates10418573prelates
preparer12169643preparer
presager1138443presager
prester93519623pr_ester
prevailer1445153prevailer
preventer1438593preventer
pricer103918293pri__cer
pricier113313113pri_cier
pricker154013413pri_cker
prickier16368143prickier
prier75027763pri___er
priested1138393priested
primage12169143primage_
primages13159273primages
primatal1247133primatal
primavera1642403primavera
primer105118683pri__mer
primmer134310163pri_mmer
prinker133412743pri_nker
printed104016373pri_nted
printers103214903pri_nters
printery13318433pri_ntery
priorate10411733priorate_
priorates11410763priorates
prisoner1048573prisoner
prissier10157873prissier
privacies1646803privacies
privacy1744233priva_cy
privateered1751693privateered
privation14311173privation
privatise14167763privatise
privatised16134993privatised
privatises15187403privatises
privatism16176933privatism
privatist14228783privatist
privative17188293privative
privatives18186473privatives
privatize23167043privatize
privatized25195643privatized
privatizes24156813privatizes
privet113821343priv__et
privets122910053privet_s
privies122414263priv_ies
privities14312043privities
privity15268313privit_y
prizer174714883pri__zer
probate11414483probate_
probated13410863probated
probates12414283probates
profaner13197943profaner
profiter132710203profiter
prolate9419793prolate_
promoter12311453promoter
prompter1437983prompter
pronate9418873pronate_
pronated11414053pronated
pronates10418373pronates
pronator10311783pronator
prorate9418733prorate_
prorated11513713prorated
prorates10418073prorates
prosateur1143583prosateur
prover113819723prov__er
provider1436703provider
provoker1784913provoker
pyruvate1643073pyruvate_
pyruvates1743133pyruvates
rater54943283_r__ater
ravager1136563_ravager
rebater93517913_rebater
relater73723143_relater
righter113212383_righter
rioter64817283_ri_oter
ritter63822423_ri_tter
rivage1038843_rivage_
rivages1138873_rivages
rivaled1138933_rivaled
river85731693_riv__er
riveted11258573_riveted
riveters11228163_riveters
sprinter103810813spri_nter
treater74219833tr_eater
trimeter10310083trimeter
triter65120593tri__ter
upriver12196933upriv__er
urinate7315363urinate_
urinated9311613urinated
urinates8314133urinates
urinator847843urinator
writer94416513wri__ter

Search took 10 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.843211970.3
2DLD Change Limit1461621618.62616944.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911619.53218746.4
 
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.