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

105 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
populated1422880(None) 
copulated142710481copulated
populate122812091populate_
populates132710671populates
copulate122614112copulate_
copulates132612462copulates
depopulated1743642depopulated
lobulated12106422lobulated
loculated1288312loculated
modulated1336712modulated
oppilated1444582oppilated
ovulated1237082_ovulated
peculated142310852peculated
populace14256252populace_
populaces15195712populaces
postulated1377652postulated
repopulated1644472repopulated
sporulated1345262sporulated
adulated1039753_adulated
ambulated1457133ambulated
amputated1444463amputated
angulated1139223angulated
annulated1038603annulated
canulated12310673canulated
capsulated1545663capsulated
coagulated1496533coagulated
collated113615063co_llated
conflated1539333conflated
copulae112810623copula_e_
corelated12411823corelated
cumulated14237843cumulated
cupulate122810033cupulate_
depilated1339653depilated
depopulate1544413depopulate_
depopulates1644033depopulates
depurated1338183depurated
emulated11310793_emulated
epilated11310753_epilated
fabulated1546323fabulated
formulated1645563formulated
inoculated1347593inoculated
insulated10310713insulated
jaculated19289053jaculated
jugulated1844023jugulated
ligulated11247363ligulated
lobulate1078833lobulate_
loculate101011403loculate_
lunulated1036783lunulated
maculated142411503maculated
modulate1138593modulate_
modulates1238053modulates
moulted103310313mo_ul_ted
operated11512223_operated
opiated1039483_op_iated
oppilate1245863oppilate_
oppilates1345453oppilates
osculated1298143osculated
outpopulated1792023outpopulated
ovulate1039453_ovulate_
ovulates1148523_ovulates
oxalated1695323_oxalated
papulae11249363papula_e_
peculate122414673peculate_
peculates132112543peculates
pixilated1944543pixilated
plated95225773__p_lated
polluted1135433po_lluted
poplitei1245483pop_litei
poppled11339243poppl__ed
popular11319573popula__r
popularised1653783popularised
popularized2554743popularized
popularly1663843popularly
populating1547663populating
population14810023population
postdated1346883postdated
postulate1169813postulate_
postulates1268963postulates
poulard10299733po_ula_rd
poularde11276573po_ularde
poulter93712013po_ul_ter
pouted94021393po_u__ted
promulgated1752293promulgated
propagated1644633propagated
pullulated1343253pullulated
pulsated1136853__pulsated
pupated12319353__pupated
pustulated1375543pustulated
regulated11310463regulated
replated112817523rep_lated
repopulate1445203repopulate_
repopulates1544893repopulates
rosulate8310903rosulate_
scopulate1366553scopulate_
simulated1238283simulated
solated83618023so__lated
speculated15186613speculated
sporulate1146953sporulate_
sporulates1246483sporulates
stipulated1345593stipulated
tabulated1237303tabulated
tegulated1146633tegulated
tubulated1256063tubulated
ululated947663_ululated
undulated11310083undulated

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.420425454.8
2DLD Change Limit1486411056.95321378.0
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.