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

123 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
intimae910975(None) 
intima81910031intima_
intimal9109941intimal
intimas9119581intimas
intimate101013831intimate
intime81014271intim_e
antimale10312462antimale
antiman9313882antiman
intimacy1544902intimacy
intimated121010892intimated
intimater111110582intimater
intimates111013312intimates
intine61021982inti_ne
intitle7610582intitle
airtime948063airtim_e
anima74620073an_ima_
animal85016253an_imal
animas84418723an_imas
animate91617213an_imate
anime75423203an_im_e
antae56828293ant__ae
antiar6317173anti_ar
anticar9312663anticar
antifat10314253antifat
antigay1148223antigay
antijam1648283antijam
antimask1446573antimask
antimere10410683antimere
antimine10714753antimine
antique1638883antique
antirape10410113antirape
antisag838043antisag
antitax1447853antitax
antiwar1037963antiwar
anytime1246043anytim_e
betime105914833betim_e
bigtime1235753bigtim_e
centime114513033centim_e
cnidae978143cn_idae
entia5318203enti_a_
entice81316863enti_ce
entire61617703enti_re
entitle7610293entitle
estimate10912003estimate
gingivae1352173gingivae
inanimate1146993inanimate
incisal947383incisal
incise83515333inci_se
incite83618733inci_te
income10712093incom_e
indican1048243indican
indicate11313353indicate
indie63721473indi__e
indite73520323indi_te
inertiae8411473inerti_ae
inflame1256963inflame
inhuman1265483inhuman
inhumane1364743inhumane
inhume1196583inhum_e
inia45024703in_i_a_
initial7311883initial
initiate8412693initiate
inmate82917363in__mate
inside7613453insi_de
insigne837673insigne
instigate1048613instigate
intake10510863int_ake
intense72511903intense
interage9314493interage
intermale11712313intermale
intermat101114613intermat
interne73218153interne
inthral10249463inthral
inti46626083inti___
intifada12102943intifada
intifadeh16112143intifadeh
intimacies1446413intimacies
intimately1545103intimately
intimaters1297853intimaters
intimidate13146053intimidate
intimist10410213intimist
intines7921113intines
intis55121643inti__s
intitled967343intitled
intitles8710003intitles
intitule867423intitule
intomb1036403intom_b
intombed1363733intombed
intombs1144153intombs
intonate8310923intonate
intone61115433int_one
intreat7416303intreat
intricate11411193intricate
intrigue945233intrigue
intrude837403intrude
intubate1047533intubate
intwine1038513intwine
inutile739883inuti_le
invital1046953invital
invite93715033invi_te
invitee103713543invitee
minima105512653min_ima_
minimal114010603min_imal
minimax18376013min_imax
minutiae1045593minuti_ae
mistime11312613mistim_e
onetime937623onetim_e
optima10106533optima_
optimal1145783optimal
optime1079353optim_e
patinae95414403patinae
retime85321803retim_e
retinae75517333retinae
stime76521803_stim_e
time66235023__tim_e
ultima836313ultima_
ultimas936363ultimas
ultimate1049203ultimate
unciae83215313unci_ae
untame82513603untam_e
untie54425493unti__e
untimed102713373untimed
uptime1067673uptim_e

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271237.53317792.0
3Display Results1231230.406303.0
 (SQL Overall)1786911238.37521336.2
 
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.