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

113 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
riptide103688(None) 
riptides1136411riptides
lipide93511062lip_ide
peptide122910682peptide
raphide13138072raphide
reptile93914082reptile
airtime948063airtime
baptise1139553baptise
baptize2036983baptize
betide95115973_betide
bigtime1235753bigtime
biocide1237323biocide
biotite9311033biotite
captive1438973captive
citied94014143ci_tied
depside1138403depside
diamide1138473diamide
diopside1245643diopside
dioxide1656303dioxide
dipeptide1544463dipeptide
dirtied93210853dirtied
divide113410893di_vide
emptied1297393emptied
eruptive1345793eruptive
fictile1238023fictile
fictive1537023fictive
gipsied1135873gipsied
hiplike1637603hiplike
hipline12311423hipline
hippie132811243hippi_e
imide85716893_i_mide
inside7613453_inside
intime81014273_intime
intine61021983_intine
iodide84812933_iodide
kiltie103210963kilti_e
lipid85916173lip_id_
lipides103810623lip_ides
lipids94310923lip_ids
liplike1337283liplike
lipoid9411043lipoid_
lipoids1038233lipoids
mistime11312613mistime
nitid61817833ni_tid_
nitride82811243nitride
optime1079353_optime
peptid112712373peptid_
peptides132610263peptides
peptids12239323peptids
peptize20279483peptize
pitied94017253pi_tied
pride84724733__pride
pristine10313503pristine
ragtime1036163ragtime
raphides14188393raphides
rapid86422033rap_id_
rapider1067903rap_ider
rapids94913893rap_ids
rapine85023083rap_ine
rapture937383rapture
ratine65131823r_atine
ratite65022423r_atite
rawhide14134973rawhide
repaid94716323repaid_
repine85627813rep_ine
replied103914453replied
reprice113212833reprice
reprise92715043reprise
reptiles103913063reptiles
reside74224933r_eside
restive10315933restive
retie55735303r_eti_e
retied75924983r_etied
retile65929673r_etile
retime85321803r_etime
retine66237333r_etine
retire64927013r_etire
riblike1337333riblike
ride55945133r___ide
rifted104115313rifted_
rifting113515003rifting
rigid7913893ri_gid_
rimfire1243793rimfire
ringside1045403ringside
rioted73416373rioted_
rioting82716393rioting
ripe66038923rip___e
riped85226433rip_ed_
ripened1038203ripened
riping93821613rip_ing
riposte9269623riposte
ripped114419013ripped_
ripping123315743ripping
ripple103413913rip_ple
rippled123110273rippled
rite45849453ri_t__e
routine72615903routine
rupture966163rupture
rutile65217683r_utile
septime1138803septime
shipside1445033shipside
tide55237383___tide
tiptoe838283tipt_oe
tiptoed1036143tiptoed
tittie63213153titti_e
topside1037733topside
trioxide1644793trioxide
triplite1039103triplite
triptane1047563triptane
tripwire1343603tripwire
upside9289803_upside
uptime1067673_uptime
yippie13277843yippi_e

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 Limit1340271137.45317983.0
3Display Results1131130.0333424.2
 (SQL Overall)1786911137.89222642.0
 
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.