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

219 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
reales6493412(None) 
rales54947491r_ales
realer63528591realer
realest73322431realest
realms84913491realms
reals55038651real_s
reaves94127571reaves
regales83520791regales
resales74724901resales
ales47067102__ales
areoles71016952areoles
bales76250082_bales
beadles103414732beadles
beagles103212122beagles
belles85325992belles
ceases84427072ceases
creases94020962creases
creates95225202creates
creoles9913322creoles
dales66439742_dales
dealer74122142dealer
dealers84118612dealers
deals65435342deal_s
deaves105319532deaves
deles65139252de_les
eagles73819162_eagles
eases56041612_eases
eaves85231992_eaves
erases64425402erases
feases95422922feases
feazes184514172feazes
females12310662females
gales65442482_gales
greases84816712greases
greaves113311442greaves
hales85449842_hales
healed105121442healed
healer94221802healer
healers104319462healers
heals85733452heal_s
heaves124120302heaves
kales95730982_kales
leases65428112leases
leaves94222382leaves
males75049792_males
mealies92821932mealies
meals75933372meal_s
measles92412752measles
merles85322762merles
pales75753802_pales
peaces106324082peaces
peages94321842peages
pealed95322802pealed
peals75235492peal_s
peases85229472peases
peles75738082pe_les
presales10315262presales
races74943242r_aces
rages64539442r_ages
rajes125022782r_ajes
rakes94440352r_akes
rale45050562r_ale_
rapes75740722r_apes
rares55247442r_ares
rases55447212r_ases
rates55352012r_ates
raves85441972r_aves
raxes124729392r_axes
razes145032702r_azes
reaches123423202reaches
reacts83616602reacts
readds84111642readds
reader73628292reader
readers83823772readers
readies83324712readies
reads64835272rea_ds
real45750292real__
realia6314592realia
realise73021812realise
realises82420182realises
realism93115922realism
realist73225382realist
realizes173116842realizes
really93315612really
realm75621622real_m
realness8410442realness
realter73716312realter
realters83614042realters
realties8514852realties
realty92713692realty
reamed94326122reamed
reamer84325212reamer
reamers94221082reamers
reams75729622rea_ms
reaped94122452reaped
reaper84223142reaper
reapers93520452reapers
reaps75626192rea_ps
reared75930012reared
rearer64928912rearer
rearers74323562rearers
rearms85114652rearms
rears54739652rea_rs
reatas64021012reatas
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reavers108320742reavers
rebates95123182rebates
rebbes10313532rebbes
rebels84518132rebels
recalls92613622recalls
recanes93222262recanes
recces10614912recces
redates83423872redates
reddles93315772reddles
redes65139122re_des
redleg839262redleg
redlegs936822redlegs
redoes74623752redoes
redyes104214082redyes
reeled74725532reeled
reeler63822572reeler
reelers73520272reelers
reels55333262reel_s
rees45364192re__es
reeves94721492reeves
refaces123216742refaces
refalls103312242refalls
refels94618052refels
refiles104122422refiles
reflet94024232reflet
reflets103513152reflets
reflew12389452reflew
reflex16359512reflex
reflies104418532reflies
regale74821452regale_
regaled93615962regaled
regaler83814622regaler
regalers94311132regalers
reges65628782re_ges
reglet73724232reglet
reglets83512982reglets
reglues838712reglues
reives95723042reives
relaces93420882relaces
relates73731432relates
relaxes143215322relaxes
relays94316752relays
relet54749822re_let
relets64025672re_lets
relies65036422relies
remakes134116172remakes
remates93827112remates
renames92418052renames
rentes65431192rentes
repaves123513652repaves
repels84318762repels
repled93319772repled
replies94521042replies
resale64025542resale_
rescales103414572rescales
resees63827482resees
reshes94124362reshes
resiles74026542resiles
resoles73823652resoles
retables101712672retables
retakes113718862retakes
retapes93917422retapes
retaxes143615092retaxes
reties65436192reties
retiles74426992retiles
reuses66025522reuses
revalues1137882revalues
revels94220572revels
reviles104421352reviles
revues9813902revues
rewakes144614982rewakes
rewaxes173911332rewaxes
rexes124526952re_xes
rials55026672rial_s
rifles94217702rifles
riles55343642r_iles
rilles64725502rilles
robles85321692robles
roles56747982r_oles
rubles83921702rubles
rules55234252r_ules
sales56055592_sales
scales84529312scales
sealed74328362sealed
sealer63928962sealer
sealers74323552sealers
seals54839692seal_s
selles64426982selles
shales94731252shales
spales84728102spales
stales65538292stales
swales93920762swales
tales55451372_tales
teals56234132teal_s
teases65426272teases
teazles16308922teazles
teles54536002te_les
treacles1039702treacles
treadles939702treadles
trebles9311442trebles
ureases74416722ureases
vales85434262_vales
vealed103916322vealed
vealer94016542vealer
vealers103214292vealers
veals84926192veal_s
wales86142832_wales
wealds10459102wealds
weals85428742weal_s
weaves123616372weaves
whales124716942whales
zeals145320852zeal_s

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit825512192.59631799.3
3Display Results2192190.0633476.2
 (SQL Overall)1786912192.76564626.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.