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

227 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
riels5512133(None) 
ariels65119371ariels
oriels64914621oriels
reels55333261reels
rials55026671rials
riel46432391riel_
riles55343641riles
rills55032711rills
ails45654722ai_ls
ariel55228972ariel_
arils58732202ari_ls
artels66216232artels
axels126313632axels
bels66142492_bels
bield84614652bield
bields94110002bields
biers76225222biers
biles75542142biles
bills75632862bills
birls74023162birls
briefs115510072briefs
briers85319732briers
bries74942152brie_s
brills84916292brills
ceils75019402ceils
cels65534972_cels
chiels115115932chiels
creels84416942creels
criers83918582criers
cries75438402crie_s
deils65722862deils
dels56745472_dels
dials64925342dials
diel59034612diel_
dies55653532die_s
diets66026642diets
dills65530972dills
diols65521012diols
dirls64720502dirls
driers74516732driers
dries64733672drie_s
drills74414202drills
drivels11397922drivels
duels65619232duels
eels46536742_eels
els37645722__els
feels85223042feels
fiefs116213702fiefs
field95015322field
fields104211042fields
files85441272files
fills84632372fills
fils75838702fi_ls
friers94718932friers
fries85535602frie_s
frills94414222frills
fuels87117352fuels
gels56836102_gels
gies55641432gie_s
gills64728192gills
gimels938892gimels
girls64518392girls
griefs10418722griefs
grills74314802grills
gruels73910152gruels
heels85625532heels
heils85222192heils
hies74842842hie_s
hills85431352hills
ills47030422_ills
ires45639282ire_s
jills125122822jills
keels94622412keels
kiefs126112212kiefs
kiers95320102kiers
kills94526182kills
koels94613902koels
krills104211282krills
libels85112692libels
liens56525502liens
liers55130402liers
lies46454202lie_s
lieus56218482lieus
mels65941532_mels
miens76118302miens
miles74645072miles
mills75435052mills
mils66045342mi_ls
nills54926672nills
nils46132462ni_ls
noels56418702noels
oils46337982oi_ls
oriel54920422oriel_
peels75226422peels
piers75926332piers
pies66949612pie_s
piles74742612piles
pills74130972pills
pixels15478532pixels
priers84521192priers
pries74339532prie_s
prills84015612prills
rails55937402rails
rales54947492rales
ratels64518212ratels
ravels94717072ravels
reals55038652reals
rebels84518132rebels
rebs65733562r_ebs
recs65734182r_ecs
reds56042872r_eds
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reel45240532reel_
rees45364192r_ees
refels94618052refels
refs75732242r_efs
regs55436572r_egs
reifs84819092reifs
reins56234562reins
reis45343232r_eis
rely75428952r_ely
rems66237722r_ems
repels84318762repels
reps65937952r_eps
res35565042r_e_s
rets45352562r_ets
revels94220572revels
revs75027052r_evs
rheas84816952rheas
rial45938102rial_
rias45540602ri_as
ribes75530172ribes
ribs65833032ri_bs
ricers84120992ricers
rices75536152rices
ricks115126132ricks
riders74123902riders
rides66140822rides
ridgels9348022ridgels
rids56539562ri_ds
rifely123710032rifely
riffs115114612riffs
rifle85518332rifle
rifles94217712rifles
rifs74929012ri_fs
rifts85718642rifts
rigs55137602ri_gs
rile45650542ri_le
riled65833252riled
riley84420582riley
rill45140912ri_ll
rille55728732rille
rilles64725502rilles
rimers84522552rimers
rimes75634542rimes
rims65936312ri_ms
rinds64826152rinds
rings65029172rings
rinks94827102rinks
rins46153202ri_ns
riots54922012riots
ripely112511152ripely
ripens85012172ripens
ripes75435772ripes
rips66237442ri_ps
risers64624782risers
rises55244042rises
risks94917062risks
risus54216392risus
rites54442552rites
rivals94213182rivals
rivers94626542rivers
rives85336002rives
rivets94417112rivets
riyals94111082riyals
roes45954142roe_s
roils54826792roils
roles56747982roles
rolls55326232rolls
rotls55620162rotls
rowels94515452rowels
rubels84112992rubels
ruers515019412ruers
rues46044482rue_s
rules55234252rules
ryes75529352rye_s
seels55632822seels
sels46345982_sels
shiels95418922shiels
sials54227242sials
sills55135992sills
spiels85317952spiels
taels56822072taels
teels55726372teels
tels46841692_tels
tiers55526522tiers
ties45248322tie_s
tiles55542102tiles
tills54631712tills
tils45739622ti_ls
tirls54519802tirls
trials64319882trials
triens65417542triens
triers64321522triers
tries55742812trie_s
trills64319852trills
triols66117802triols
urials64415192urials
veils84918802veils
vials85822382vials
viers85621952viers
vies75238632vie_s
views11489642views
vills86429322vills
viols86118102viols
virls85618602virls
wield95213912wield
wields10469622wields
wiles85437872wiles
wills84528962wills
wries85827742wrie_s
yield9519692yield
yields10466842yields
yills83921552yills
zills144020782zills

Search took 4 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.326548131.9
2DLD Change Limit538002272.93618324.3
3Display Results2272270.0633603.2
 (SQL Overall)1786912273.32553741.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.