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
ruboff143519(None) 
ruboffs1543111ruboffs
runoff1235411runoff
boff124727322__boff
buyoff1754232buyoff
cutoff1436562cutoff
putoff1436422putoff
rebuff1437012rebuff
ripoff1436432ripoff
rubout8313552rubout
ruff105127652ru__ff
runoffs1343012runoffs
baff124632263__baff
biff125026873__biff
boffo136010373__boffo
boffs134915503__boffs
brushoff1942603brushoff
bubo85621903bubo__
buboed113010003buboed
buboes104513993buboes
buff125229853__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
muff124723853mu__ff
off96331633___off
payoff1736023payoff
puff125525433pu__ff
putoffs1543333putoffs
quaff201311353qu_aff
quiff201111553qu_iff
raff104933043r__aff
rakeoff1743463rakeoff
rebody1238153rebody
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
rebop9313283rebo_p
rebops10311423rebops
rebore86625643rebore
reborn810016953reborn
rebozo1737323rebozo
rebuffs1533403rebuffs
reroof9315003reroof
ribose839893ribose
riff104430093r__iff
ripoffs1543383ripoffs
robot7325973robo_t
robots8313143robots
rolf75134873r__olf
roof75738833r__oof
roofs85321153r_oofs
rub56342823rub___
rubace10310173rubace
rubati8299693rubati
rubato8319673rubato
rubbed114515083rubbed
rubber104715793rubber
rubble104315673rubble
rubbly133710613rubbly
rubby124413853rub_by
rubdown1383883rubdown
rube65532013rub__e
rubel75416833rub_el
rubels84112993rubels
rubeola9115123rubeola
rubes74928413rub_es
rubied94312403rubied
rubier84814733rubier
rubies84420333rubies
rubigo935043rubigo
rubious938273rubious
ruble74521253rub_le
rubles83921703rubles
rubouts937973rubouts
rubric1097823rubric
rubs66133493rub__s
rubus76415053rub_us
ruby97819943rub__y
ruffe114713813ru_ffe
ruffs114516743ru_ffs
rufous948263rufous
rugola736293rugola
rugosa734563rugosa
rugose737283rugose
rugous739643rugous
rumor71011323rumo_r
rumors81110393rumors
rumour8127373rumour
runout6414873runout
scoff134413343_scoff
setoff1238913setoff
shroff1538493shroff
shutoff1693193shutoff
suborn8310003suborn
tipoff1436383tipoff
toff105929903__toff
tuff104528523tu__ff
turnoff1344013turnoff

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161147.48315062.9
3Display Results1141140.0333454.5
 (SQL Overall)1786911147.68923239.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.