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

171 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
rifts8571864(None) 
drifts10499891drifts
gifts96214961gifts
grifts104511681grifts
lifts85719061lifts
rafts87820631rafts
riffs115114611riffs
rifs74929001rif_s
rift75642331rift_
riots54922011riots
sifts84918921sifts
airts55626342airts
aits46355532ai_ts
biffs134814412biffs
bints76130182bints
bits66148162bi_ts
bitts75022592bitts
brits76433082bri_ts
britts84813442britts
cists76624532cists
clifts11519152clifts
crafts115312742crafts
crits75527572cri_ts
crofts114910592crofts
diets66026642diets
diffs126315482diffs
difs86027322dif_s
dints67431312dints
dirts66824462dirts
dits56450522di_ts
drafts105012532drafts
drift95722842drift_
drifty13418222drifty
efts76519482_efts
fiats85324482fiats
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fists85527542fists
fits76043462fi_ts
frits86129102fri_ts
fritts94613192fritts
gift86735792gift_
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592gi_ts
grafts105013252grafts
griffs13398992griffs
grift95924462grift_
griots74713642griots
grists74716482grists
grits65529582gri_ts
hafts116219462hafts
hefts116218152hefts
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
ifs67124242_if_s
its35538832_i_ts
jiffs185710312jiffs
jilts124717412jilts
kifs116023512kif_s
kilts95122182kilts
kists95822112kists
kits86441772ki_ts
krafts13438852krafts
lefts86517812lefts
lift76942722lift_
lilts55822802lilts
lints57137192lints
lists56628692lists
lits46252492li_ts
lofts85518362lofts
miffs134512882miffs
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
nifty115211632nifty
nits45741642ni_ts
pints75936222pints
pits66348742pi_ts
prints84320102prints
raffs115017522raffs
raft76245912raft_
rants55935342rants
rats46260372r_ats
refits94017652refits
refs75732242ref_s
reft75141272reft_
reifs84819092reif_s
rents55935182rents
resifts10378702resifts
rests54935872rests
rets45352562r_ets
rials55026672rials
rias45540592ri_as
riata54618022riata
riatas63915092riatas
ribes75530172ribes
ribs65833022ri_bs
rices75536152rices
ricks115126132ricks
rictus8379192rictus
rides66140812rides
rids56539552ri_ds
riels55121332riels
rif65951562rif__
rife74632322rif_e
rifer84721982rifer
rifest93114582rifest
riff104430102rif_f
rifle85518332rifle
rifles94217702rifles
rifted104115312rifted
rights104019332rights
rigs55137592ri_gs
riles55343642riles
rills55032712rills
rimes75634542rimes
rims65936302ri_ms
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192ri_ns
riot45947212riot_
ripes75435772ripes
rips66237432ri_ps
rises55244042rises
risks94917062risks
risus54216392risus
rite45849452ri_te
rites54442552rites
ritz135129982ri_tz
rives85336002rives
rivets94417112rivets
roots55933672roots
rots46454092r_ots
routs57133412routs
ruffs114516742ruffs
runts55927632runts
rusts55026992rusts
ruts44541492r_uts
ryots85313782ryots
shifts124412942shifts
shrifts1335962shrifts
sift710740662sift_
silts55330822silts
sits45050202si_ts
softs85019232softs
swifts12408172swifts
thrifts1335522thrifts
tiffs114414882tiffs
tilts55325612tilts
tints56030922tints
tits46145042ti_ts
tofts84919242tofts
tufts85713272tufts
wafts116920552wafts
wefts116715492wefts
wifes114522562wifes
wifty144212092wifty
wilts85023502wilts
wists86728522wists
wits76044872wi_ts
wrists95415642wrists
writs86624382wri_ts
zits136030292zi_ts

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 Filter178691538001.000178691.0
2DLD Change Limit538001716.1738715.4
3Display Results1711710.360475.0
 (SQL Overall)1786911717.53323721.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.