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

177 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
rakis9532344(None) 
kakis86116841kakis
ragis66325601ragis
rais45252621ra_is
rakes94440351rakes
raki87127831raki_
rakish134313961rakish
rakus94413671rakus
ranis55235831ranis
sakis95323671sakis
ahis76135382_ahis
ais39083572_a_is
akin86328032_akin
amis66445322_amis
anis45746462_anis
araks94820882arak_s
arks85936872ark_s
arris56824682arris
arsis55722422arsis
axis116127912_axis
bakes117035372bakes
basis75429862basis
brakes124923122brakes
cadis84428502cadis
cakes116037672cakes
crakes124921812crakes
crasis85020472crasis
dais57040702da_is
daks97130602dak_s
drakes114715862drakes
fakes126032482fakes
fakir125111492fakir
fakirs13468082fakirs
gadis74825292gadis
gratis74819242gratis
haiks125120932haiks
hajis156716282hajis
hakes126034302hakes
hakim14311832hakim
hakims1537302hakims
hakus125114112hakus
jakes165023642jakes
kadis105921062kadis
kakas85117342kakas
kaki76520912kaki_
khakis1265852khakis
kis78051482__kis
lakes95737652lakes
lakhs125210342lakhs
lapis76223152lapis
laris54737462laris
makes115336852makes
makos116518362makos
mavis105622722mavis
maxis145721562maxis
nabis76020582nabis
naris55735292naris
nazis145216082nazis
oaks86527902oak_s
oasis56422552oasis
padis86227142padis
paiks114719852paiks
paris75145942paris
pavis106422732pavis
pikis115116392pikis
praxis154012252praxis
qadis155917852qadis
rabbis102613162rabbis
rabic93817402rabic
rabid84520782rabid
rabies85226022rabies
races74943242races
rachis114017652rachis
racism103214192racism
racist82822792racist
racks115028852racks
radii64016412radii
radio64922492radio
radios74018672radios
radish103516912radish
radius73914872radius
radix134414602radix
rads56046602ra_ds
raffs115017522raffs
rafts87820632rafts
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragi56032282ragi_
rags55448372ra_gs
rai37658222ra_i_
raia46638382ra_ia
raias54631122raias
raid55243072ra_id
raids65827512raids
rail46147762ra_il
rails55937402rails
rain46251732ra_in
rains55140232rains
raise54828052ra_ise
rajas127317722rajas
rajes125022782rajes
rake84841572rak_e
raked105831422raked
rakee96031172rakee
rakees104516972rakees
raker94529792raker
rakers104123572rakers
raking114728422raking
raku85423772rak_u
rales54947492rales
rami66034092rami_
ramie75027822ramie
ramies84630462ramies
ramps96224632ramps
rams65950772ra_ms
ramus76418282ramus
rands65930452rands
rani46640112rani_
ranid66429332ranid
ranids75118702ranids
rankish14510382rankish
ranks95225732ranks
rants55935342rants
rapes75740722rapes
raphis114014322raphis
rapid86422032rapid
rapids94913892rapids
rapist82520672rapist
raps66247732ra_ps
rares55247442rares
ras37575392ra__s
rases55447212rases
rasps74316662rasps
rates55352012rates
ratio55227582ratio
ratios64922672ratios
ratos55528762ratos
rats46260372ra_ts
raves85441972raves
ravin85624652ravin
ravins94622562ravins
ravish123414032ravish
rawin85521472rawin
rawins95617622rawins
rawish123012912rawish
raws75238212ra_ws
raxes124729392raxes
rayas85922052rayas
rays77642352ra_ys
razes145032702razes
reis45343232r_eis
rotis56327062rotis
rumakis1335532rumakis
rykes125513032rykes
sadis64930852sadis
sakes95540752sakes
saki85628482saki_
saris54544952saris
satis55633682satis
skis84825292_skis
takas95520682takas
takes94437792takes
takin94921302takin
takins105117402takins
tamis76728732tamis
tapis75028862tapis
taxis126821972taxis
tikis95615972tikis
traiks104013712traiks
uraris63817272uraris
vakil1259792vakil
vakils1337592vakils
wadis95223962wadis
wakes126633652wakes
yagis95416572yagis
yaks116025202yak_s

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 Filter178691538000.313570897.8
2DLD Change Limit538001771.45037103.4
3Display Results1771770.0503540.0
 (SQL Overall)1786911771.81398560.9
 
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.