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 “riff” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
riff10443010(None) 
biff125026891biff
diff116228841diff
griff124416461griff
iff96730391_iff
jiff175321411jiff
miff125625061miff
raff104933041raff
rif65951561ri_f
rife74632321rife
riffs115114611riffs
rifs74929001rifs
rift75642331rift
ruff105127651ruff
tiff104727721tiff
aff95537612_aff
baff124632272baff
biffs134814412biffs
biffy164711132biffy
boff124727332boff
brief105422602brief
buff125229862buff
caff125631672caff
cliff135917132cliff
coff126930782coff
cuff125327992cuff
daff115229682daff
dif76846902di_f
diffs126315482diffs
difs86027322difs
doff116225782doff
draff125615662draff
drift95722842drift
duff114326642duff
eff96128622_eff
fief107331362fief
fife106027702fife
gaff114828152gaff
gift86735792gift
gliff124915662gliff
grief95319782grief
griffe13438092griffe
griffs13398992griffs
grift95924462grift
gruff124712142gruff
guff114624932guff
huff135623842huff
if57239952_i_f
iffy135312282_iffy
ifs67124242_ifs
jiffs185710312jiffs
jiffy21458312jiffy
kief117128402kief
kif105941182ki_f
kifs116023502kifs
lief76036992lief
life75433732life
lift76942722lift
luff104426702luff
miffs134512882miffs
miffy163910202miffy
muff124723862muff
naff105128932naff
off96331632_off
puff125525432puff
quiff201111562quiff
raffs115017522raffs
raft76245912raft
reef74938212reef
ref66053292r_ef
refs75732242refs
reft75141272reft
reif76937652reif
reifs84819092reifs
reify114814972reify
ria36745502ri_a
rial45938092rial
rias45540592rias
rib56848032ri_b
ribs65833022ribs
rice64942912rice
rich97025542rich
rick107334652rick
rid46754622ri_d
ride55945122ride
rids56539542rids
riel46432382riel
rifer84721982rifer
riffed133811562riffed
riffle124210232riffle
rifle85518332rifle
rifts85718642rifts
rig46748122ri_g
rigs55137592rigs
rile45650532rile
rill45140902rill
rim56052272ri_m
rime65138882rime
rims65936302rims
rimy96621282rimy
rin36663182ri_n
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
riot45947212riot
rip56851302ri_p
ripe66038922ripe
ripoff1436432ripoff
rips66237432rips
rise45945232rise
risk85724102risk
rite45849452rite
ritz135129982ritz
rive75537722rive
rolf75134872rolf
roof75738832roof
ruffe114713812ruffe
ruffs114516742ruffs
sift710740662sift
skiff153612802skiff
sniff113915862sniff
spiff133616402spiff
stiff114219242stiff
tariff12711362tariff
teff106023762teff
tiffs114414882tiffs
toff105929902toff
tuff104528522tuff
waff134228042waff
whiff17310062whiff
wife105228022wife
yaff135324262yaff

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298721330.76339150.7
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.079165608.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.