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

148 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
oxalate145762(None) 
oxalated1695321oxalated
oxalates1557061oxalates
alate55340322__alate
dealate83617842dealate
malate84624552_malate
oblate82214742o_blate
ovulate1039452ovulate
oxidate1537022oxidate
palate84226782_palate
abate76627843__abate
ablate82219213_ablate
acylate12310533acylate
adulate8313233adulate
agate66525153__agate
alae45643753__ala_e
alane56135613__alane
alated75625143__alated
alates64833963__alates
analyte10158813analyte
balata8614673_balata
blate75933783__blate
bullate93415073bullate
carate84734003_carate
chelate122914893chelate
cholate122114933cholate
clavate1238713clavate
collate92919683collate
conflate13311173conflate
copulate122614113copulate
corelate10516013corelate
cyanate12259703cyanate
dealated103213603dealated
dealates92716683dealates
deflate113613943deflate
delate73827753_delate
dilate73220693_dilate
egalite8311563egalite
elate55335883__elate
emanate9312473emanate
emulate9314123emulate
epilate9314283epilate
escalate1039323escalate
evaluate11287793evaluate
exabyte1943523exabyte
exalt123018533exal_t_
exalted1537393exal_ted
exalter1437563exal_ter
exalts13328313exal_ts
excavate2045053excavate
exclave1945193exclave
expiate16910593expiate
exudate1537093exudate
falcate12311613_falcate
fellate10313433fellate
folate93320393_folate
galatea839953_galatea
galeate83916783_galeate
gallate83417123gallate
gelate73421253_gelate
gradate9511233gradate
halite93624233_halite
hamate113319833_hamate
hyalite13229473hyalite
imamate1138103imamate
inflate10312313inflate
isolate7313923isolate
karate105320923_karate
khanate1437073khanate
lanate6421263_lanate
late47560483___late
lobulate1078833lobulate
localite101411543localite
loculate101011403loculate
malates93522603_malates
maleate94117543_maleate
modulate1138593modulate
oblates91913243o_blates
obovate1235463obovate
obviate1235783obviate
ocellate1037873ocellate
ocreate93711743ocreate
odonate848403odonate
oleate6318883o_leate
oolite63319603o_olite
opaline9412483opaline
operate9615733operate
opiate8513463o_piate
oppilate1245863oppilate
orality101111683orality
orate55133303o__rate
ornate6315143o_rnate
osculate101010613osculate
outate62923403o_utate
outdate83016423outdate
outrate72323183outrate
ovality1377593ovality
ovate84214393o__vate
overate10620963overate
overlate11716283overlate
ovulated1237083ovulated
ovulates1148523ovulates
oxalating1745803oxalating
oxalic1537093oxal_ic
oxalis1339223oxal_is
oxalises1538503oxalises
oxazine2354773oxazine
oxidase1543543oxidase
oxidated1745033oxidated
oxidates1636333oxidates
oxlike17307473ox_like
ozonate1646863ozonate
palace104516913_palace
palates93624933_palates
paleate94120003_paleate
palmate113215233_palmate
palpate113213923_palpate
placate11312433placate
planate9314573planate
plate74635113__plate
populate122812093populate
prelate9519693prelate
prolate9419793prolate
ramate83921683_ramate
reflate103516263reflate
relate64033633_relate
replate93420053replate
reslate73520593reslate
rosulate8310903rosulate
salute64418023_salute
savate9313783_savate
scalade10359263scalade
scalage103110533scalage
scalare93311833scalare
slate55438283__slate
sodalite9109593sodalite
solate64526073_solate
stylate10179773stylate
sublate9315363sublate
toeplate1047613toeplate
ululate749963ululate
uralite71714103uralite
vacate11314553_vacate
vallate103016563vallate
valuate102512733_valuate
valvate133710813_valvate
velate93720143_velate
violate10311553violate

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271486.95319276.1
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.42224075.9
 
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.