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

182 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
imitates1031050(None) 
imitate9310871imitate_
imitated1138261imitated
agitates9310882agitates
amirates101114802amirates
emirates101214852emirates
imamates1237662imamates
imitator1047112imitator
imitators1147012imitators
initiates9411182initiates
instates81615832instates
irritates977222irritates
metates92720012_metates
militates11310882militates
mutates92215792_mutates
acetates102013073acetates
agitate8312063agitate_
agitated1038413agitated
amidases1136653amidases
amirate91115953amirate_
amities9317383amit_ies
amitoses1039063amitoses
amputates1345263amputates
animates101316423animates
aviates10313083avi_ates
cavitates14168963cavitates
ciliates10413453cili_ates
citrates102315093_citrates
climates12311973climates
cogitates1247863cogitates
criminates1448003criminates
dictates11311383dictates
digitate1098683digitate_
digitated1286963digitated
dilates83220663_dilates
dimidiates1444603dimidiates
dimities11314003dimit_ies
dominates12311743dominates
eliminates1246973eliminates
emanates10311333emanates
emigrates1248583emigrates
emirate91015833emirate_
emitted103010853emit_ted
emitter93211083emit_ter
emitters10349643emit_ters
emulates10312573emulates
epilates10313503epilates
epitases1038933epitases
estates74520183_estates
filiates11412663fili_ates
fixates1737393_fixates
frigates12310933frigates
fumigates1545573fumigates
geminates12310043geminates
gestates93213733gestates
hesitates1269793hesitates
ideates8313733i_deates
images91411463im__ages
imamate1138103imamate_
imbitter12265283imbit_ter
imbitters13274503imbit_ters
imblazes2144723imblazes
imbricates1645303imbricates
imbrutes1244203imbrutes
imides94515343imi__des
imines84918353imi__nes
imitable1239123imitable
imitating1238763imitating
imitation11510853imitation
imitations1259963imitations
imitative1446333imitative
immigrates1544023immigrates
immolates1346453immolates
impales113311763im_pales
impastes12238193impastes
impetrates1445453impetrates
implicates1646783implicates
imputes1138083im_putes
indicates12312583indicates
inflates11512193inflates
ingates82716913i_ngates
ingrates9514173ingrates
initiate8412693initiate_
initiated10510113initiated
inmates92715783i_nmates
instate71616483instate_
instated91613343instated
intakes11310943i_ntakes
intimates111013313intimates
iodates8312903i_odates
iodinates1048203iodinates
iritises839983iritises
irrigates1057253irrigates
irritate867873irritate_
irritated1076133irritated
isolates8613513isolates
iterates81317823iterates
lactates10311233lactates
laminates112712903laminates
levitates1247873levitates
ligates82318383_ligates
limites92915453limi__tes
litigates1048003litigates
litotes7311183_litotes
malates93522613_malates
mates75251363_m__ates
mattes85624533_mat_tes
meditates1239813meditates
metages102714973_metages
metate82720533_metate_
migrates111112853migrates
milages103114403_milages
militate10311673militate_
militated1248803militated
mimetites1346823mimetites
ministates1246743ministates
mintages111110513mintages
minutes93513443_minutes
mirages102213533_mirages
misate81222693_misate_
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
misstates11710633misstates
mistakes141213413mistakes
mites75141803_mi__tes
mitigates1248253mitigates
mitises9315543_mitises
mitoses9312183_mitoses
mitres83922073_mit_res
mitten83914093_mit_ten
mittens9349883_mit_tens
mitts75523753_mit_t_s
mottes85523693_mot_tes
mutases92012043_mutases
mutate83017483_mutate_
mutated102712253_mutated
nictates1039593nictates
nictitates1244953nictitates
nidates8311893_nidates
nitrates82516223_nitrates
nominates11311053nominates
notates72817483_notates
nutates73214973_nutates
omitted10347893omit_ted
omitter9298503omit_ter
omitters10277653omit_ters
opiates9312143opi_ates
oxidates1636333oxidates
palmitates1445453palmitates
pectates122213953pectates
pirates93020333_pirates
primates121515933primates
privates131812383privates
restates83423443restates
rotates72819773_rotates
ruinates8311883ruinates
ruminates11410193ruminates
sanitates9611733sanitates
satiates8314633satiates
shitakes1546113shitakes
sibilates1148443sibilates
silicates11311523silicates
simitars1046483simita_rs
simulates1139853simulates
situates8310373_situates
smilaxes1744653smilaxes
smites83921923smi__tes
smithies1337913smithies
smitten936693smit_ten
states64337083__states
tates55444983___tates
testates83615453testates
titivates1246433titivates
titrates82314663_titrates
unitages938273unitages
unstates81314993unstates
upstates10189643upstates
urinates8314133urinates
veritates12310973veritates
vitiates112311433_vitiates
vizirates2144663vizirates

Search took 9 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 Limit1461621827.81318707.5
3Display Results1821820.0802275.0
 (SQL Overall)1786911828.34621410.4
 
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.