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

184 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
interim991287(None) 
interims101013071interims
enteric9314212enteric
icteric1138032icteric
inherit10312972inherit
inter55028492inter__
intercom1248682intercom
interfirm1446442interfirm
interior8513102interior
intermit101213592intermit
intermix17156872intermix
intern64016542inter_n
interne73218152interne
interns73116772interns
inters64328052inter_s
intertie8317612intertie
iterum837902i_terum
niterie7313742niterie
untrim8310682unt_rim
antefix1745053antefix
anterior8611063anterior
anteroom101010103anteroom
antherid12611093antherid
antrum8611313ant_rum
apteria9312923apteria
apterium1249143apterium
asteria7316203asteria
asterism10413273asterism
cinerin9313823cin_erin
coterie9417403coterie
dineric10310973din_eric
enter54726383enter__
entera64216833enter_a
enteral73516453enteral
entered82718883entered
enterer72015633enterer
enterics10312863enterics
entering91920053entering
enteron7313343enteron
enters64425643enter_s
hinter94021303hinter__
hinters103719583hinter_s
iatric8312173iat_ric
icterics1247073icterics
icterus936083icterus
imperia1148423imperia
imperil1147683imperil
imperium1446423imperium
inarm7314423in_ar_m
indri6310793in_dri_
indris7311963in_dris
inert53234373in_er_t
inertia7410203in_ertia
inerts64517023in_erts
infer84215033infer__
inferior1156423inferior
inferno1045603inferno
infers93615443infer_s
infirm1137043infir_m
inform11310153infor_m
inhere9313713inher_e
inhered11313163inhered
inheres10315173inheres
inhering12913713inhering
inherits11310103inherits
inker94421093inker__
inkers104018833inker_s
inner54920633inner__
innerly1037143innerly
inners63919353inner_s
innerve1056753innerve
inseam8329993inse_am
insert64325253inser_t
inserts74013993inserts
intarsia845763intarsia
integer837993integer
integral946793integral
integrity1345173integrity
intend72310373inte_nd
intends8239963intends
intense72511903intense
intent63122773inte_nt
intents72115703intents
interact10316473interact
interage9314493interage
interbed112413103interbed
intercity14410003intercity
intercoms1349343intercoms
intercut10411113intercut
interdict12410213interdict
interest8319183interest
interfile12411043interfile
interiors9513573interiors
interjoin1647893interjoin
interknit1358333interknit
interlaid1049353interlaid
interlap1048593interlap
interlay11310043interlay
interline91218013interline
interlink131310663interlink
intermat101114613intermat
intermits111212203intermits
internal8414093internal
interned93016653interned
internee82718523internee
internes82721233internes
interning10315253interning
internist9414883internist
interred92615263interred
interrex15249823interrex
interring10315423interring
interrow1147143interrow
intersex15209733intersex
interterm1148813interterm
interties9320343interties
intertill9410423intertill
interunit959843interunit
interval11710473interval
interview1547363interview
interwar1148263interwar
inthral10249463inthral
inti46626083int__i_
intima81910033int__ima
intime81014273int__ime
intis55121643int__is
intort6418923intor_t
intorts7310973intorts
intreat7416303intreat
intrepid1145363intrepid
intro54915853int_r_o
introit7414533introit
intron64215023int_ron
intros64215773int_ros
intuit6314083int_uit
inturn63411563intur_n
inturns73210133inturns
inverity1447963inverity
inverse10249643inverse
invert94120083inver_t
invertin11910233invertin
inverts103211953inverts
item65620383i_te__m
lingerie959203lingerie
linter64625343linter__
linters73822633linter_s
listeria839453listeria
midterm12316013midter_m
minter84425103minter__
minters93822473minter_s
misterm114314513mister_m
niter55028973niter__
niteries8318383niteries
niters64624213niter_s
nitery94412173niter_y
nitric82512063nit_ric
nitrid72812233nit_rid
nitril62511533nit_ril
pretrim11310783pretrim
pterin81014153_pterin
retrim83514883ret_rim
santeria8311673santeria
sinter63625923sinter__
sintered92213903sintered
sintering101014803sintering
sinters74024083sinter_s
steric8317063_steric
term66233153__ter_m
tinter63923643tinter__
tinters74221113tinter_s
trim65329523__t_rim
untrims938613unt_rims
uteri51012983_uteri_
winter94222803winter__
wintered122111573wintered
winterer112110443winterer
winterier1238343winterier
wintering13412363wintering
winterish1546643winterish
winterize2146923winterize
winterly14306743winterly
winters103720483winter_s
wintertime1543813wintertime
wintery13399753winter_y
wisteria1147773wisteria

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.406440125.6
2DLD Change Limit1340271846.98319193.3
3Display Results1841840.0802300.0
 (SQL Overall)1786911847.46923924.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.