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

107 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
riptides113642(None) 
riptide1036891riptide_
lipides103810622lip_ides
peptides132610272peptides
raphides14188392raphides
reptiles103913072reptiles
airtimes1037503airtimes
aphides134711203_aphides
apsides103911303_apsides
baptises1238923baptises
baptizes2136843baptizes
betides104915273_betides
biocides1336943biocides
biotites10310093biotites
captives1538623captives
cities84524853ci_ti_es
depsides1238503depsides
diamides1238823diamides
diopsides1345293diopsides
dioxides1756203dioxides
dipeptides1643803dipeptides
dipodies1238413dipodies
dipsades1246493dipsades
dirties83119383dirti_es
ditties83116983ditti_es
divides123211453di_vides
empties11712243empti_es
eruptives1443853eruptives
fifties132111083fifti_es
gipsies1039903gipsi_es
hiplines13310593hiplines
hippies142813753hippi_es
imides94515343_i_mides
insides8512653_insides
intines7921113_intines
iodides93811613_iodides
irides74519123_i_rides
iritises839983iritises
kilties113014143kilti_es
kitties113213623kitti_es
lapides103012043lap_ides
lipide93511063lip_ide_
lipids94310923lip_id_s
lipoids1038233lipoid_s
mistimes12612613mistimes
mitises9315543mi_tises
nifties102612503nifti_es
nitrides92910703nitrides
optimes1148473_optimes
otitides937293otitides
peptide122910693peptide_
peptids12239333peptid_s
peptizes21269863peptizes
pieties9419223pieti_es
pities83828083pi_ti_es
prides94324183__prides
rachides141511223rachides
ragtimes1135823ragtimes
raphide13138073raphide_
rapider1067903rap_ider
rapidest1138543rap_idest
rapids94913893rap_id_s
rapines95120863rap_ines
raptures1037583raptures
ratines75328583r_atines
ratites74920683r_atites
rawhides15145543rawhides
repines94927383rep_ines
replies94521043repli_es
reprices122913353reprices
reprises102615463reprises
reptile93914083reptile_
resides84523283r_esides
reties65436193r_eti_es
retiles74426993r_etiles
retimes95020173r_etimes
retines75134673r_etines
retires74726213r_etires
rhinitides1443673rhinitides
rictuses1037563rictuses
rides66140813r___ides
righties12711573righti_es
rimfires1344203rimfires
ringsides1144753ringsides
ripes75435773rip___es
ripostes10239093ripostes
ripples113513293rip_ples
rites54442553ri_t__es
ritzes154812943ri_t_zes
routines82214363routines
ruptures1056683ruptures
rutiles74315843r_utiles
septimes1238303septimes
shipsides1544883shipsides
sixties14310973sixti_es
tides64830153___tides
tiptoes939173tipt_oes
titties73617363titti_es
topsides1137203topsides
trioxides1744493trioxides
triplites1148283triplites
tripodies1246573tripodies
triptanes1147463triptanes
tripwires1443283tripwires
upsides10319633_upsides
uptimes1177553_uptimes
yippies14279293yippi_es

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621077.28320068.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.75223051.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.