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

114 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
ruboff143520(None) 
ruboffs1543121ruboffs
runoff1235411runoff
boff124727332__boff
buyoff1754232buyoff
cutoff1436562cutoff
putoff1436422putoff
rebuff1437022rebuff
ripoff1436432ripoff
rubout8313562rubout
ruff105127652ru__ff
runoffs1343012runoffs
baff124632273__baff
biff125026893__biff
boffo136010373__boffo
boffs134915503__boffs
brushoff1942603brushoff
bubo85621913bubo__
buboed113010003buboed
buboes104513993buboes
buff125229863__buff
buyoffs1842433buyoffs
coff126930783__coff
cuboid1139503cuboid
cuff125327993cu__ff
cutoffs1533603cutoffs
dieoff1335503dieoff
doff116225783__doff
duff114326643du__ff
dustoff1445053dustoff
feoff10711053_feoff
flyoff1444023flyoff
fuckoff1842393fuckoff
gruff124712143gru__ff
guff114624933gu__ff
huff135623843hu__ff
jumpoff2442243jumpoff
layoff1545093layoff
luff104426703lu__ff
muff124723863mu__ff
off96331633___off
payoff1736023payoff
puff125525433pu__ff
putoffs1543333putoffs
quaff201311353qu_aff
quiff201111563qu_iff
raff104933043r__aff
rakeoff1743463rakeoff
rebody1238153rebody
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
rebop9313283rebo_p
rebops10311433rebops
rebore86625653rebore
reborn810016963reborn
rebozo1737323rebozo
rebuffs1533403rebuffs
reroof9315003reroof
ribose839893ribose
riff104430103r__iff
ripoffs1543383ripoffs
robot7325973robo_t
robots8313153robots
rolf75134873r__olf
roof75738833r__oof
roofs85321153r_oofs
rub56342823rub___
rubace10310173rubace
rubati8299693rubati
rubato8319683rubato
rubbed114515083rubbed
rubber104715793rubber
rubble104315673rubble
rubbly133710613rubbly
rubby124413863rub_by
rubdown1383893rubdown
rube65532013rub__e
rubel75416833rub_el
rubels84112993rubels
rubeola9115123rubeola
rubes74928413rub_es
rubied94312413rubied
rubier84814743rubier
rubies84420343rubies
rubigo935053rubigo
rubious938283rubious
ruble74521253rub_le
rubles83921703rubles
rubouts937983rubouts
rubric1097823rubric
rubs66133493rub__s
rubus76415063rub_us
ruby97819943rub__y
ruffe114713813ru_ffe
ruffs114516743ru_ffs
rufous948273rufous
rugola736293rugola
rugosa734563rugosa
rugose737283rugose
rugous739653rugous
rumor71011323rumo_r
rumors81110403rumors
rumour8127383rumour
runout6414873runout
scoff134413343_scoff
setoff1238913setoff
shroff1538503shroff
shutoff1693203shutoff
suborn8310013suborn
tipoff1436383tipoff
toff105929903__toff
tuff104528523tu__ff
turnoff1344013turnoff

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 Filter1786911127160.423422437.4
2DLD Change Limit1127161145.81019400.3
3Display Results1141140.0333454.5
 (SQL Overall)1786911146.26628517.6
 
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.