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 “oxalated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
oxalated169532(None) 
oxalate1457621oxalate_
oxalates1557061oxalates
alated75625152__alated
dealated103213602dealated
exalted1537392exal_ted
ovulated1237082ovulated
oxidated1745032oxidated
abated95918453__abated
ablated102513443_ablated
acylated1437873acylated
adulated1039753adulated
alate55340333__alate_
alates64833973__alates
belated103520013_belated
chelated142610483chelated
collated113615063collated
conflated1539333conflated
copulated142710483copulated
corelated12411823corelated
dealate83617843dealate_
dealates92716683dealates
deflated133412303deflated
delated93722873_delated
dilated93115823_dilated
elated74725823__elated
emanated1139163emanated
emulated11310793emulated
epilated11310753epilated
escalated1247303escalated
evaluated13276653evaluated
exacted1737303exa_cted
exalter1437563exal_ter
exapted1736073exa_pted
excavated2243893excavated
expiated18168523expiated
explanted1944973explanted
exulted1536303exul_ted
falcated1438483_falcated
fellated1239563fellated
galatea839973_galatea
galeated104111583_galeated
gelated93615643_gelated
gradated1157433gradated
halted105019603_hal_ted
inflated12410863inflated
isolated9410523isolated
lanated8313203_lanated
lated65240673___lated
lobulated12106423lobulated
loculated1288313loculated
malate84624563_malate_
malates93522613_malates
malted94819863_mal_ted
modulated1336713modulated
oblate82214743o_blate_
oblates91913243o_blates
obviated1444563obviated
ocellated1245453ocellated
operated11512223operated
opiated1039483o_piated
oppilated1444583oppilated
orated74221503o__rated
osculated1298143osculated
outdated1012513193outdated
outlasted10128353outlasted
outlawed1238033outlawed
outrated92219313outrated
ovulate1039453ovulate_
ovulates1148523ovulates
oxalating1745803oxalating
oxalises1538503oxalises
oxidate1537023oxidate_
oxidates1636333oxidates
ozonated1864593ozonated
palaced124110783_palaced
palate84226793_palate_
palates93624943_palates
palmated132511003_palmated
palpated13249763_palpated
pixilated1944543pixilated
placated1338453placated
plated95225773__plated
populated14228803populated
reflated123514293reflated
related83327573_related
replated112817523replated
reslated93517523reslated
salted74121203_sal_ted
saluted84511713_saluted
slated75028313__slated
solated83618023_solated
sublated11311503sublated
ululated947663ululated
unabated11310133unabated
vacated1349353_vacated
valeted1139013_valeted
valuated12239203_valuated
violated1237883violated

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.453394461.4
2DLD Change Limit146162996.76621602.4
3Display Results99990.0462152.2
 (SQL Overall)178691997.26524596.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.