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

110 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
loculated128831(None) 
lobulated12106421lobulated
loculate101011401loculate_
copulated142710482copulated
flocculated1952302flocculated
inoculated1347592inoculated
jaculated19289052jaculated
ligulated11247362ligulated
lobulate1078832lobulate_
located103114182loc__ated
loculed10317652locul__ed
lunulated1036782lunulated
maculated142411502maculated
modulated1336712modulated
osculated1298142osculated
ovulated1237082_ovulated
peculated142310852peculated
populated14228802populated
aculeated1247723_aculeated
acylated1437873_acylated
adulated1039753_adulated
ambulated1457133ambulated
angulated1139223angulated
annulated1038603annulated
arcuated1138803arcu_ated
calculated1577803calculated
canulated12310673canulated
circulated1588063circulated
coagulated1496533coagulated
cocreated142710093cocreated
collated113615063co_llated
conflated1539333conflated
copulate122614113copulate_
copulates132612463copulates
corelated12411823corelated
cumulated14237843cumulated
curated104717583__curated
ejaculated20165903ejaculated
emulated11310793_emulated
escalated1247303escalated
exculpated2243923exculpated
fabulated1546323fabulated
flocculate1743203flocculate_
flocculates1852743flocculates
formulated1645563formulated
incubated1446983incubated
inculcated1546173inculcated
inculpated1545733inculpated
inoculate1149623inoculate_
inoculates1248703inoculates
inosculated1444673inosculated
insulated10310713insulated
jaculate172311783jaculate_
jaculates182810363jaculates
jugulated1844023jugulated
lacerated122210683lacerated
lactated1138873lac_tated
lacunate10128963lacunate_
ligulate92510253ligulate_
liquated1835493liqu_ated
lobated102610943lo__bated
localised12167863localised
localite101411543localite_
localites111210433localites
localized21168833localized
locate83919843loc__ate_
locater93113603loc__ater
locates93218813loc__ates
locomoted1444103locomoted
locular938953locula__r
locule83412033locul__e_
locules92812603locul__es
locustae10274713locustae_
loricated1247893loricated
louted74920693lo_u__ted
lucubrated1542603lucubrated
lunated8310823l__unated
lunulate838253lunulate_
luxated1535713l__uxated
maculate122815623maculate_
maculates132013723maculates
modulate1138593modulate_
modulates1238053modulates
moulted103310313mo_ul_ted
occulted1344263occul_ted
ocellated1245453_ocellated
osculate101010613osculate_
osculates11109393osculates
ovulate1039453_ovulate_
ovulates1148523_ovulates
oxalated1695323_oxalated
peculate122414673peculate_
peculates132112543peculates
populate122812093populate_
populates132710673populates
postulated1377653postulated
regulated11310463regulated
rosulate8310903rosulate_
sacculated1546623sacculated
sculpted1354883_sculpted
simulated1238283simulated
solated83618023so__lated
speculated15186613speculated
sporulated1345263sporulated
tabulated1237303tabulated
tegulated1146633tegulated
tubulated1256063tubulated
ululated947663_ululated
undulated11310083undulated
vacuolated1643973vacuolated

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.436409841.7
2DLD Change Limit1486411106.89021573.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.37224239.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.