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

120 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
tictocs114590(None) 
tictacs1145791tictacs
tictoc1036001tictoc_
lictors93212592lictors
tactics1149322tactics
ticktock1543012ticktock
ticktocks1642992ticktocks
tictac1036562tictac_
tiptoes939172tiptoes
tiptops1136072tiptops
victors123311182victors
actors81016763_actors
arctics1138953arctics
bicrons113410473bicrons
binocs1039923bi_nocs
biotics113812173biotics
bittock1544433bittock
bittocks1644443bittocks
crocs95722433__crocs
deictics1345563deictics
diatoms1039073diatoms
dicots94915793dic_ots
dictions111812673dictions
dictums1235553dictums
dittos74111973ditto_s
doctors1039993doctors
evictors13276853evictors
factors12912123factors
ficoes114613463fic_oes
fictions132410743fictions
hectors123513263hectors
ichors11310423_ichors
icons76516493_ic_ons
ictic9311803_ictic_
ictus7249703_ict_us
lectors93415763lectors
lictor83610853licto_r
lintols7339553lintols
microns113814783microns
micros104115363micro_s
miotics112710653miotics
nicols8810243nic_ols
nitons64614903ni_tons
nostocs947553nostocs
piceous11310693piceous
picnics13297343picnics
picots104616443pic_ots
pintoes95117713pintoes
pintos86021293pinto_s
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
pitons85319043pi_tons
rectors93520523rectors
rectos85718783recto_s
ricracs1136363ricracs
rictus8379193rict_us
riotous739863riotous
sectors93116453sectors
sickos125112033sicko_s
sitcoms1145533sitcoms
stictions1148353stictions
tacos77023553tac_o_s
tactic10612753tactic_
tactions102912423tactions
tacts76524123tact__s
tarocs84615663t_arocs
tattoos738643tattoos
tautogs875413tautogs
tectonics1345953tectonics
tectums11306423tectums
testons7313563testons
ticals83214713tic_als
tickers133617723tickers
tickets134113683tickets
tickles133416853tickles
ticks115823293tic__ks
ticktack1543643ticktack
ticktacks1643393ticktacks
tics65729633ti___cs
tictocked18152723tictocked
tiglons837343tiglons
tigons74112263ti_gons
tilters73315953tilters
tilths9459373tilt_hs
tilts55325613tilt__s
timeous938403timeous
tincts84510803tinct__s
tinters74221113tinters
tints56030923tint__s
tipstock1643733tipstock
tipstocks1743423tipstocks
tiptoe838283tipto_e
tiptoed1036143tiptoed
tiptop1036103tipto_p
tiros54524893ti_ro_s
titans63414913ti_tans
titers64526413ti_ters
tithes94720213ti_thes
titis56023813ti_t_is
titles63719923ti_tles
titres64718933ti_tres
tits46145043ti_t__s
titters74219623titters
titties73617363titties
tittles73413253tittles
tittups933353tittups
tractors10312563tractors
tricots9311563tric_ots
trictracs1344043trictracs
tritons73814883tritons
tutors6912333t_utors
tycoons1235173tycoons
vectors123212593vectors
viators102712023viators
vicious1239493vicious
victims1436003victims
victor113210673victo_r
victory15326983victory
wittols1035733wittols

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.423422437.4
2DLD Change Limit1340271206.70319995.1
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.17224915.1
 
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.