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

194 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
tipcat1031265(None) 
tipcart1148831tipcart
tipcats1137101tipcats
hepcat13611822hepcat
tical76021492ti_cal
tincal83913362tincal
tinct76126232tinc_t
tipcarts1244572tipcarts
tippet103917872tippet
tomcat101013452tomcat
topcoat1179312topcoat
apical10913903apical
bipack1636523bipack
bobcat12411253bobcat
cat58282343___cat
circa9311403circa_
copycat1647593copycat
dicast9315573di_cast
dicot85429093di_cot
dicta84915633di_cta
didact10711203didact
diktat11310693diktat
dipnet91317473dipnet
dipsas9359893dipsas
dipt77339323dip__t
diquat1639763diquat
discant103017253discant
ducat86225903_ducat
epact94921533_epact
epical10413393epical
expat14313813exp_at
fiat76646643fi__at
finca104714503finca_
fincas113512073fincas
fiscal1139333fiscal
hepcats1436473hepcats
ikat87626643_i_kat
impact122310453impact
incant82418503_incant
ipecac1264623_ipecac
kismat123011673kismat
licht104723493li_cht
licit74327683li_cit
lipa68425923lip_a_
mica86428253mi_ca_
micas96823053mi_cas
midcap1336473midcap
misact10316683misact
miscast11312413miscast
miscut10614813miscut
miseat82925703miseat
mudcat11311203mudcat
muscat10314653muscat
nicad8312613ni_cad
nipa69421633nip_a_
nipas77116673nip_as
ocicat101412813ocicat
oilcan837793oilcan
pact86648723__pact
pat58089463__p_at
peat65967933__peat
phat95837863__phat
pica85831493pi_ca_
pical95524373pi_cal
picas94626523pi_cas
piccata1345703piccata
picot95031013pi_cot
pipal95118353pip_al
pipet95533323pip_et
pipit95224873pip_it
plat66048873__plat
prat65952043__prat
repeat85127213repeat
ripest84317943ripest
ripost83615003ripost
riprap1055513riprap
ripsaw1134283ripsaw
scat65848373__scat
siccan1037593siccan
sippet103519393sippet
spat66548523_sp_at
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
spicate113214193spicate
splat76129343_splat
sprat76635973_sprat
tacet75840023t_acet
tacit76333673t_acit
tact67349033t_ac_t
tailcoat1046853tailcoat
taipan82410663taip_an
tapa65129143tap_a_
tapas74627713tap_as
tapeta8310693tapeta
tappet103820113tappet
tat37690293t___at
teacart91113193teacart
teat45963633t__eat
tecta74215523t_ecta
tepa66021683tep_a_
tepal76319583tep_al
tepas76521683tep_as
tercet83624913tercet
that75639323t__hat
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
thecate123210023thecate
threat95020463threat
throat94819753throat
tiara5315913tiara_
tiaras6314553tiaras
tibia7312403tibia_
tibiae838483tibiae
tibial849843tibial
tibias839953tibias
tic56343463ti_c__
ticals83214713ti_cals
ticced11438443ticced
tick106231223ti_c_k
ticket124524853ticket
ticks115823293ti_cks
tics65729633ti_c_s
tictac1036563tictac
tidal64516443ti_dal
tidbit938493tidbit
tight93626503ti_ght
tikka835573tikka_
tikkas934523tikkas
tilak91011553ti_lak
tilt46252423ti__lt
timbal102510753timbal
tincals93610643tincals
tincts84510803tincts
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tinman82411143tinman
tinplate1047743tinplate
tinpot8312513tinpot
tint46758863ti__nt
tip56551223tip___
tipi69924433tip__i
tipis76019923tip_is
tipoff1436383tipoff
tipped114418263tipped
tipper103918413tipper
tippets11339373tippets
tipple103411913tipple
tippy125411793tip_py
tips66436763tip__s
tipsy106010503tip_sy
tiptoe838283tiptoe
tiptop1036103tiptop
tit36771053ti___t
titan53318173ti_tan
titbit839823titbit
titian62512663titian
titman82711003titman
titrant7315193titrant
titrate72215573titrate
toccata1144943toccata
toccate1138773toccate
toecap1037323toecap
tomcats11127773tomcats
topaz16315323top_az
topcoats1245193topcoats
topical1139953topical
topmast1138123topmast
toucan838193toucan
tract75635713trac_t
treat56240353t_reat
tricot8317753tricot
tripack1565673tripack
tripart9311433tripart
triplet94319213triplet
trippet113714113trippet
triptan947543triptan
trocar848773trocar
twat75831513t__wat
typal105311153typ_al
typecast1545273typecast
typical1436343typical
typist1139823typist
upcast102710093_upcast
vicar10513863vi_car
vinca105315163vinca_
vincas113912453vincas
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
wildcat1346293wildcat
zincate1838533zincate

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161945.40620850.2
3Display Results1941940.0633079.4
 (SQL Overall)1786911945.84530571.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.