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

139 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
imamate113810(None) 
imamates1237661imamates
emanate9312472emanate
hamate113319832_hamate
imitate9310872imitate
immane1038882im_mane
inmate82917362i_nmate
malate84624552_malate
mammate104411272_mammate
mismate111415352mismate
nizamate1943532nizamate
ramate83921692_ramate
abate76627843__abate
agamete1037403agamete
agate66525153__agate
agemate101210583agemate
alate55340323__alate
amaze166016603__amaze
amirate91115953amirate
animate91617213animate
bedmate1239433bedmate
bromate11313553bromate
carate84734003_carate
chamade15138453chamade
clavate1238713clavate
climate11312833climate
comate104124843_comate
cremate113816183cremate
cyanate12259703cyanate
damage10410783_damage
dealate83617843dealate
diamante1186423diamante
dilatate947773dilatate
divagate1344783divagate
emaciate1248753emaciate
emanated1139163emanated
emanates10311333emanates
emirate91015833emirate
emulate9314123emulate
fermate122813003fermate
flatmate1346393flatmate
formate123115093formate
fumarate1345683fumarate
gamete9313593_gamete
gemmate12418383gemmate
gradate9511233gradate
hamates122917683_hamates
humate113214443_humate
ideate7313683i_deate
image81411293i__mage
imagine1037883imagine
imam81718333imam___
imams91511113imam__s
imaret81121233imaret_
imarets9138643imarets
imblaze2044323imblaze
imbrute1144913imbrute
imitated1138263imitated
imitates10310503imitates
immature1244443im_mature
immolate1246543immolate
immune1035433im_mune
immure1036033im_mure
impale102811663im_pale
impaste11258003impaste
impute1038043im_pute
inanimate1146993inanimate
indagate1047193indagate
inflate10312313inflate
ingate73018243i_ngate
ingrate8715123ingrate
inmates92715783i_nmates
innate63917313i_nnate
instate71616483instate
intimate101013833intimate
iodate7313503i_odate
irate55627983i__rate
isolate7313923isolate
iterate71119113iterate
karate105320923_karate
khanate1437073khanate
lanate6421263_lanate
limbate1139213lim_bate
madame1139853_madame
magmata1237463_magmata
magnate10512703_magnate
malates93522603_malates
maleate94117543_maleate
mama86231593_mama__
mamas95930773_mama_s
mamie95826003_mam_ie
mammae94613213_mammae
mammati10398373_mammati
mammee94417853_mammee
mammet94319253_mammet
mammie94313783_mammie
manage93818903_manage
manat76039993_manat_
manatee9317663_manatee
manats84623463_manats
mandate10315573_mandate
manmade1237963_manmade
marmite112413993_marmite
mate65154223___mate
matte75626843_ma_tte
metate82720533_metate
miasmata1244503miasmata
migrate101314173migrate
misate81222693_misate
misdate101413963misdate
mismade12129353mismade
mismake15139373mismake
mismated131111333mismated
mismates121114563mismates
misrate91319143misrate
mutate83017483_mutate
nizamates2043273nizamates
oxalate1457623oxalate
palate84226783_palate
palmate113215233palmate
placate11312433placate
planate9314573planate
playmate1566463playmate
plumate1149803plumate
primate111516283primate
remate84428683_remate
samite83020603_samite
savate9313783_savate
seatmate1048573seatmate
sigmate10710143sigmate
simulate10311133simulate
squamate1945783squamate
stomate9313123stomate
summate113611663summate
tamale83717403_tamale
teammate1245613teammate
titanate897173titanate
vacate11314553_vacate
vicarate1378603vicarate

Search took 7 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.406440125.6
2DLD Change Limit1340271395.94022563.5
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.39227955.4
 
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.