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

108 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
ripraps113494(None) 
riprap1055511riprap_
rewraps12136562rewraps
ricracs1136362ricracs
ripsaws1243822ripsaws
bewraps14135403bewraps
bitmaps1344253bitmaps
citrals91111673citrals
coprahs14338153coprahs
copras103517153copra_s
craps95328643__craps
digraph14146643digraph
digraphs15105753digraphs
dipsas9359893dipsa_s
dirams94413703di_rams
entraps9109763entraps
enwraps1284833enwraps
fraps105620553__fraps
hijrahs2043443hijrahs
hijras1635773hijra_s
ihrams1137173_ihrams
inwraps12105253inwraps
kidnaps1453323kidnaps
libras83711703libra_s
lipreads1144223lipreads
liras56021983li_ra_s
mihrabs1444203mihrabs
mishaps1438723mishaps
nipas77116673nip_a_s
paps86443453__p_aps
pipals104213643pip_als
prams96125513__prams
praos74923563__praos
prats76333393__prats
praus74621753__praus
prays105022433__prays
preps96220693__preps
prewraps15114053prewraps
props95726883__props
raps66247733___raps
rattraps1044823rattraps
reaps75626193r__eaps
recaps103615733r_ecaps
redcaps1247073redcaps
redraws11218473redraws
remaps105012873r_emaps
reparks13249513reparks
repass84114703rep_ass
repays113813973rep_ays
repeals94014523repeals
repeats94316053repeats
replans92814943replans
replays12399763replays
repps95114343rep__ps
repress92712683repress
repros84216003repr_os
repumps1334403repumps
resprays1344713resprays
rewrap11127533rewrap_
rewrapt12138113rewrapt
rials55026673ri__als
rias45540593ri__a_s
riatas63915093riata_s
ribgrass1143423ribgrass
ricrac1037013ricra_c
riflips1234163riflips
riojas1335813rioja_s
ripens85012173rip_ens
ripes75435773rip__es
ripoffs1543383ripoffs
riposts9279403riposts
rippers114115033rippers
ripples113513293ripples
riprapped1341973riprapped
rips66237433ri___ps
ripsaw1134283ripsa_w
ripsawn1242503ripsawn
ripstops1265013ripstops
ristras7311563ristra_s
ritards8439943ritards
rituals738353rituals
rivals94213183ri_vals
riyals94111083ri_yals
rupiahs1253333rupiahs
satraps95011643satraps
scraps106017243_scraps
shiplaps1544363shiplaps
sirrahs10377303sirrahs
sirras63814863sirra_s
sirups83710533si_rups
spirals93212513spirals
sprags95715823_sprags
sprats85819933_sprats
sprays115913643_sprays
straps87721783_straps
tiaras6314553tiara_s
tipcats1137103tipcats
tiptops1136073tiptops
traps75727483__traps
trigrams11116353trigrams
trigraph1445703trigraph
trigraphs1545393trigraphs
triptans1047363triptans
unwraps1255513unwraps
upprops1044223upprops
whiprays1942503whiprays
wraps105617153__wraps
zirams17438643zi_rams

Search took 7 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 Limit1340271086.45320769.7
3Display Results1081080.0333272.7
 (SQL Overall)1786911086.89225927.3
 
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.