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

154 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
populate12281209(None) 
copulate122614111copulate
populace14256251populace
populated14228801populated
populates132710671populates
copulae112810612copula_e
copulated142710482copulated
copulates132612462copulates
cupulate122810032cupulate
depopulate1544412depopulate
lobulate1078832lobulate
loculate101011402loculate
modulate1138592modulate
oppilate1245862oppilate
ovulate1039452_ovulate
papulae11249352papula_e
peculate122414662peculate
populaces15195712populaces
popular11319562popula_r
postulate1169812postulate
repopulate1445202repopulate
rosulate8310902rosulate
scopulate1366542scopulate
sporulate1146952sporulate
adulate8313233_adulate
ambulate1239733ambulate
amputate1246263amputate
angulate9312013angulate
annulate8310923annulate
apiculate13279883apiculate
canulate10314553canulate
capsulate1347563capsulate
coagulate1258083coagulate
collate92919683co_llate
conflate13311173conflate
consulate11612233consulate
copemate1439993copemate
copula102812043copula__
copular113810603copula_r
copulas113811563copula_s
copulative1747293copulative
corelate10516013corelate
cumulate123110223cumulate
cupulae11347853cupula_e
depilate11311703depilate
depopulated1743643depopulated
depopulates1644033depopulates
depurate1139983depurate
emulate9314123_emulate
epilate9314283_epilate
fabulate1339203fabulate
folate93320393fo__late
formulate1446993formulate
hamulate1359013hamulate
hoplite12311073hop_lite
inoculate1149623inoculate
insulate8312843insulate
jaculate172311783jaculate
jugulate1645483jugulate
ligulate92510253ligulate
lobulated12106423lobulated
loculated1288313loculated
lunulate838253lunulate
maculate122815623maculate
modulated1336713modulated
modulates1238053modulates
morulae958963morula_e
moulage1037903mo_ulage
noplace1137393nop_lace
oblate82214743_o_blate
operate9615733_operate
opiate8513463_op_iate
oppilated1444583oppilated
oppilates1345453oppilates
osculate101010613osculate
outate62923403_o_utate
outpopulate1592193outpopulate
ovulated1237083_ovulated
ovulates1148523_ovulates
oxalate1457623_oxalate
palate84226783__palate
papillate13127573papillate
papula103011113papula__
papular11299763papula_r
papule102212133papul__e
papulose1244533papulose
peculated142310843peculated
peculates132112543peculates
pinnulate1145763pinnulate
planulate1146903planulate
plate74635113__p_late
plumate1149803p_lumate
polite83625073po__lite
pollute937383po_llute
popelike16177853popelike
poplar103611113pop_la_r
poplars113910333pop_lars
poplitei1245483pop_litei
popple92710983poppl__e
popularise1445423popularise
popularity1754683popularity
popularize2345683popularize
popularly1663843popularly
populating1547663populating
population14810023population
populism1446073populism
populist1248203populist
populists1345493populists
populous1245953populous
postdate1139653postdate
postulated1377653postulated
postulates1268963postulates
poulard10299733po_ulard
poularde11276573po_ularde
poult76928873po_ul_t_
poulter93712013po_ul_ter
poults84613483po_ul_ts
prelate9519693p_relate
prolate9419793p_rolate
promulgate1553013promulgate
propagate1446123propagate
propylite1646713propylite
pullulate1144703pullulate
pulsate9510233__pulsate
pupate104213123__pupate
pupilage1343773pupilage
pustulate1177243pustulate
pyruvate1643073pyruvate
regulate9313023regulate
replate93420053rep_late
repopulated1644473repopulated
repopulates1544893repopulates
roulade857003ro_ulade
scopulae1254613scopula_e
simulate10311133simulate
solate64526073so__late
soulmate1047183so_ulmate
spatulate11107173spatulate
speculate13239183speculate
spiculate132210163spiculate
sporulated1345263sporulated
sporulates1246483sporulates
stipulate1147323stipulate
subulate10312743subulate
tabulate10310893tabulate
toeplate1047613toeplate
toluate7159343tolu_ate
torulae758553torula_e
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
zonulae1645963zonula_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.1731032896.0
2DLD Change Limit1461621547.62319173.8
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.85922737.1
 
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.