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

147 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
preparers1319767(None) 
preparer12169641preparer_
prepares122014161prepare_s
preavers13910262pre_avers
prefacers1636292prefacers
prepare111913622prepare__
prepared132210862prepare_d
prepaves15189192prepave_s
prepregs13144762prep_regs
prepress12137982prep_ress
presagers1236942presagers
rearers74323562_re_arers
repairers1135282_repairers
repapers1258832_repapers
bearers94619593_be_arers
breakers143810973bre_akers
clearers10349303cle_arers
comparers15319393comparers
creamers124111303cre_amers
creasers103612823cre_asers
dreamers11369003dre_amers
fearers104815273_fe_arers
greasers93410253gre_asers
hearers104319783_he_arers
pamperers15236863pamperers
paperers122410453p_aperers
parers85530743___parers
pearlers1039033p_e_arlers
pedalers11239393p_edalers
peepers113713673peep__ers
pepperers1244893pepperers
peppers103311443p_ep_pers
perjurers18224463perjurers
pervaders1544433pervaders
phreakers1834673phre_akers
pleaders113210183ple_aders
pleasers104010293ple_asers
pleaters103613793ple_aters
praters94921653pr__aters
prayers124212853pr__ayers
preachers16339573preachers
prealters1147773prealters
prearms11369173pre_ar_ms
preaver121011613pre_aver_
prebakes1639013prebake_s
precancers1645253precancers
precures12312903precure_s
predates11615813predate_s
predators12310083predators
preeners102712813pre_eners
prefacer1537983prefacer_
prefaces15311063preface_s
prefades1439533prefade_s
preferrers1542983preferrers
prefers123713333pre__fers
prefires134313283prefire_s
pregames1339003pregame_s
preggers12236833pre_ggers
prehardens1673443prehardens
preheaters1557193preheaters
prelates10418573prelate_s
preluders1234423preluders
premarkets1863633premarkets
premiers122911653pre_miers
prenames12311643prename_s
preorders1235403preorders
prepacks1836583prepa_cks
preparators1554723preparators
preparedly1842983preparedly
preparing14311643preparing
prepastes13128823prepastes
prepave14228873prepave__
prepaved16177223prepave_d
prepays1437483prepa__ys
preplaces1578743preplace_s
preppier1156643preppier_
preppies1149683preppie_s
prepreg12165963prep_re_g
prepubes1436053prepube_s
prepuces1438583prepuce_s
presager1138443presager_
presages11312203presage_s
presales10315263presale_s
preservers15115693preservers
presiders1248213presiders
pressers103215023pre_ssers
presters103419003pre_sters
prestress1138133prestress
presumers1336373presumers
pretapes122811533pretape_s
prevailers15123833prevailers
prewarms15406723prewar_ms
prewarns13456943prewar_ns
prewires133811013prewire_s
preyers124412363pre__yers
procurers1345033procurers
profaners14256213profaners
propanes122415823propane_s
properer1259203properer_
propers113619033prop__ers
proposers13228523proposers
readers83823773_re_aders
reamers94221083_re_amers
reapers93520453_re_apers
rearer64928913_re_arer_
reavers108320743_re_avers
rebaters103413943_rebaters
regalers94311133_regalers
relaters83218153_relaters
relaxers15298263_relaxers
remakers143811303_remakers
remarkers15197283_remarkers
repairer1036783_repairer_
repairs9319973_repa_irs
repanels1036783_repanels
repaper11310023_repaper_
reparks13249513_repar_ks
repartees1147253_repartees
repaves123513653_repave_s
repealers11278843_repealers
repeaters112811993_repeaters
repiners103913433_repiners
replacers13266833_replacers
repliers103710163_repliers
reporters1139173_reporters
reposers102911603_reposers
repowers13288533_repowers
repress92712683_rep_ress
retakers123511133_retakers
retarders10227573_retarders
retirers84311533_retirers
reverers113113153_reverers
rewarders13226453_rewarders
roarers73812743_r_oarers
shearers113911323she_arers
smearers10308623sme_arers
sparers94519613__sparers
spearers103711143spe_arers
spreaders1236493spre_aders
swearers11328583swe_arers
tearers75218233_te_arers
treaders93311843tre_aders
treaters83615843tre_aters
trepanners1243083trepanners
upbearers1343033upbe_arers
wearers104615903_we_arers
wreakers15328423wre_akers

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411477.50019818.8
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.71923149.5
 
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.