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

149 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
sanitate861204(None) 
sanitated1068991sanitated
sanitates9611731sanitates
agitate8312062_agitate
animate91617212_animate
capitate121712182capitate
cavitate13159832cavitate
sagittate1043602sagittate
salivate11310012salivate
sanitary1146752sanitary
sanitise81511812sanitise
sanitize171410082sanitize
satiate7315402sati_ate
sonicate10310932sonicate
acetate92514753_acetate
agitated1038413_agitated
agitates9310883_agitates
agitato856573_agitato
amirate91115953_amirate
anatase738943_anatase
animated111612373_animated
animater101512393_animater
animates101316423_animates
animato91610623_animato
annotate877713annotate
ansate64517863_an_sate
antae56828293_an_ta_e
antistate9410143_antistate
aristate8312133_aristate
aspirate1039943aspirate
aviate9315203_avi_ate
bandmate1347973bandmate
califate13310483califate
candidate1356663candidate
cantata93811813can_tata
canulate10314553canulate
capitated14159043capitated
carinate103320253carinate
cavitated15177353cavitated
cavitates14168963cavitates
cogitate1148553cogitate
craniate10312563crani_ate
denitrate10810533denitrate
dentate8315153den_tate
digitate1098683digitate
exanimate1845663exanimate
gravitate1345543gravitate
habitat12411053habitat_
habitats1346733habitats
habituate1443923habituate
hastate10313913ha_state
hesitate1169973hesitate
imitate9310873_imitate
inanimate1146993inanimate
initiate8412693_initiate
instate71616483_instate
irritate867873irritate
kalifate1556493kalifate
labiate91313573labi_ate
lactate9312703la_ctate
laminate103014633laminate
lanate6421263lan__ate
lancinate1147803lancinate
lanital7310913lanita_l
lanitals837723lanitals
lapidate1157903lapidate
levitate1137933levitate
mandate10315573man_date
marinate103017783marinate
meditate11310623meditate
militate10311673militate
ministate1147263ministate
navigate1246073navigate
nictate9310223__nictate
nidate7313783__nidate
nitrate72017013__nitrate
notate63217863__notate
nutate63017373__nutate
paginate114012443paginate
palmitate1346413palmitate
palpitate1365973palpitate
patinate103016313patinate
punctate1246473punctate
quantitate1943843quantitate
radiate83416313radi_ate
radicate11412873radicate
reanimate1148083reanimate
sabotage1144603sabotage
saccate111311763sa_ccate
sagittal943283sagittal
saithe94713913sa_it_he
salivated1337473salivated
salivates1239293salivates
samite83020603sami__te
sanative11310473sanative
sancta839833sancta__
sanctity1345593sanctity
sanicle91210263sani_cle
sanidine939853sanidine
sanitaria947063sanitaria
sanitaries1049913sanitaries
sanitating1149653sanitating
sanitation10412043sanitation
sanities81219773sanities
sanitised10147353sanitised
sanitises91111743sanitises
sanitized19138173sanitized
sanitizer18126733sanitizer
sanitizes181210133sanitizes
sanity9316203sani__ty
satiated9311603sati_ated
satiates8314633sati_ates
saturate8312813saturate
savate9313783sa__vate
scutate9310323s_cutate
senate63725173sen__ate
sensate7311893sen_sate
septate9511873s_eptate
seriate73722473seri_ate
shiitake1542883shiitake
shitake1455623s_hitake
sibilate1049533sibilate
silicate10312623silicate
sinuate7412163sin_uate
situate7410783s__ituate
sonicated1248453sonicated
sonicates11410383sonicates
spectate12248833spectate
spicate113214193s_picate
spinate93114813s_pinate
staminate1187983staminate
state56237333s___tate
stipitate1144613stipitate
striate74218953stri_ate
substate101711093substate
supinate10310313supinate
suricate10312613suricate
syndicate1544513syndicate
tannate71813523tan_nate
tunicate103310043tunicate
unitage838993_unitage
unstate71916213_unstate
vaginate123911083vaginate
validate1239003validate
vanadate1245513vanadate
vantage11109893van_tage
variate101316433vari_ate
wantage11119623wan_tage
xanthate1845713xanthate

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.406440125.6
2DLD Change Limit1461621497.40619735.6
3Display Results1491490.0602483.3
 (SQL Overall)1786911497.87222699.6
 
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.