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

132 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
preplace148898(None) 
preplaced1676481preplaced
preplaces1578751preplaces
replace113214281_replace
fireplace1644872fireplace
kreplach1942612kreplach
preface14510922pre_face
preflame1545912preflame
prelacy1437582pre_lacy
prelate9519692pre_late
prepack1757642prep_ack
prepare111913622prep_are
prepave14228872prep_ave
preplan1149952prepla_n
preplans1249612preplans
preplant12712912preplant
preprice1488872preprice
prepuce1337832prep_uce
prerace11414122pre_race
preslice1258622preslice
relace83122152_re_lace
replaced133211402_replaced
replacer12279742_replacer
replaces123114122_replaces
replate93420052_replate
anyplace1543853anyplace
areolae7811733areola_e
areolate81014453areolate
deplane10311413_deplane
displace1348653displace
emplace1338263_emplace
enlace82213233__enlace
fireplaced1842943fireplaced
fireplaces1744343fireplaces
freelance1445143freelance
homeplace1844253homeplace
kreplech1941583kreplech
misplace1437553misplace
noplace1137393_noplace
outplace1257913outplace
palace104516913p__alace
peace95026083p_e__ace
pelage9515363p_e_lage
peneplane1344663peneplane
pepla9312863p_epla__
pieplant1268733pieplant
place94824613___place
populace14256253populace
preach133613923pre__ach
preact103220393pre__act
prebade12310283pre_bade
prebake1539093pre_bake
preclude1344903preclude
predate10616893pre_date
preelect1249643preelect
preenact12410183preenact
prefaced1638423pre_faced
prefacer1537983pre_facer
prefaces15311063pre_faces
prefade1339013pre_fade
pregame1239553pre_game
prelacies13310053pre_lacies
prelates10418573pre_lates
prelaw1139103pre_la_w
prelect111013833pre_lect
prelife1279943pre_life
prelude1038013pre_lude
premade12311443pre_made
prename11412643pre_name
prentice121012353prentice
prepacked20155653prep_acked
prepacks1836583prep_acks
prepaid12310133prep_aid
prepared132210873prep_ared
preparer12169643prep_arer
prepares122014163prep_ares
prepaste12139083prepaste
prepaved16177233prep_aved
prepaves15189193prep_aves
prepay13310313prep_a_y
prepays1437483prep_ays
prepense12238943prepense
preplacing1746003preplacing
preplanned1543503preplanned
preppie1058093prep_pie
prepriced1676643prepriced
preprices1569263preprices
prepuces1438583prep_uces
prepunch1743643prepunch
prepupae1144643prepupae
presage10312293pre_sage
presale9416353pre_sale
presence122213513presence
preshape1537533preshape
presliced1435983presliced
preslices1338213preslices
pretape113511623pre_tape
pretence122312123pretence
prevalue1345073prevalue
prolate9419793pr_olate
propane112716153prop_ane
prophage1649433prophage
prophase15410243prophase
reclame11411063_reclame
reface113616353_re_face
reflate103516263_reflate
reglaze1747223_reglaze
relaced103517213_re_laced
relaces93420883_re_laces
relate64033633_re_late
repack142412163_rep_ack
repave114813873_rep_ave
replacers13266833_replacers
replan83215823_repla_n
replans92814943_replans
replant93318533_replant
replated112817523_replated
replates102919273_replates
replay113412923_repla_y
replayed14248633_replayed
replays12399763_replays
replete92912993_replete
replica1137943_replica
reprice113212833_reprice
reslate73520593_reslate
respace11310913_respace
resplice1237253_resplice
retrace91417343_retrace
someplace1544033someplace
toeplate1047613toeplate
triplane1039113triplane
workplace2042733workplace

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.406440125.6
2DLD Change Limit1461621326.98320931.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.43524033.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.