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

102 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
rumpuses123516(None) 
campuses1437772campuses
grampuses1442972grampuses
hummuses1544452hummuses
humuses1237592hum_uses
lupuses936272lu_puses
ruckuses1444912ruckuses
rumples113313132rump_les
rumpless12256542rumpless
rumpus10458892rumpu__s
wampuses1534112wampuses
ampules1189433_ampules
amuses85117943_am_uses
bemuses1139293bem_uses
campused1535253campused
composes145017113composes
computes143914553computes
corpuses12310063corpuses
crumples14348813crump_les
cultuses1037753cultuses
cupules113210263cu_pules
cuscuses1235863cuscuses
cutpurses1343313cutpurses
dufuses11436593du_fuses
fucuses12158353fu_cuses
funguses1254713funguses
grumphies1743653grumphies
guipures1143733guipures
gummoses1344743gummoses
humpless15226333humpless
iambuses1235783iambuses
imposes113213683_imposes
impulses1235223_impulses
imputes1138083_imputes
kumisses1443583kumisses
kumyses1633143kum_yses
lampases1267293lampases
limbuses1234903limbuses
lususes736713lu_suses
momuses1159263mom_uses
mouses85531423__mouses
mucuses11148513mu_cuses
muses75134303__m_uses
nimbuses1244663nimbuses
opuses84012243__opuses
outpushes1445253outpushes
priapuses1343703priapuses
primuses1237083prim_uses
prunuses1035123pru_nuses
pumpless14236373pumpless
purposes1237823purposes
purpures1276143purpures
puses75532203___puses
radiuses937043radiuses
rampages1336673rampages
rampikes1635393rampikes
rampoles1238893rampoles
rebuses94915293r_ebuses
recluses105111733recluses
recuses94619463r_ecuses
refuses104918553r_efuses
rehouses11312113rehouses
reimposes1345473reimposes
remises93423483rem_ises
remorses10311993remorses
reposes94021263r_eposes
repulses1038393r_epulses
reputes94615963r_eputes
reuses66025523r__euses
rhamnuses14102313rhamnuses
rhesuses1134893rhesuses
rhombuses1643293rhombuses
rhuses94911793r__huses
rictuses1037563rictuses
rimples113114223rimp_les
risuses73210923r_isuses
rouses65436283r__ouses
rubasses1035493rubasses
rumbles114018393rum_bles
rummages1344933rummages
rummies113212793rum_mies
rumoured1143783rumoured
rumours976373rumou_rs
rumple103913013rump_le_
rumpled123810013rump_led
rumplier1235303rumplier
rumpliest1345313rumpliest
rumps95922293rump___s
rupees8312573ru_p_ees
ruptures1056683ruptures
ruses56136583r___uses
suffuses1435833suffuses
supposes1238203supposes
surpluses1155433surpluses
tumuluses1143123tumuluses
umpires1137813_umpires
upases84112903_u_pases
uraeuses835383uraeuses
uruses63616503_u_ruses
vulguses1243503vulguses
wammuses1543493wammuses
wamuses1237023wam_uses

Search took 9 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.436409841.7
2DLD Change Limit1461621027.69019006.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911028.15621909.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.