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

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

471 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
refall9431439(None) 
befall114410641befall
recall83815731recall
refalls103312241refalls
refell94214441refell
refill94514051refill
befalls12349122befalls
befell11428712befell
begall92610722begall
dewfall1453762dewfall
fall75535312__fall
icefall1254312icefall
infall939402infall
real45750292re_a_l
really93315612re_ally
realm75621622re_alm
reals55038652re_als
rebill84713252rebill
recalls92613622recalls
reface113616352reface
refallen1136212refallen
refeel93913242refeel
refel84920812ref_el
refels94618052refels
refelt94521422refelt
refile95122372refile
refills103711422refills
refilm114311402refilm
reflag1098082reflag
refly113914562ref_ly
refold103812112refold
refuel93912622refuel
regal65023792rega_l
regale74821452regale
regally1159872regally
remail85017122remail
renail65020762renail
renal55929512rena_l
repoll8410792repoll
reroll6412682reroll
resail64418732resail
resale64025542resale
resell64215202resell
retail65522072retail
retally10413682retally
retell63813642retell
all36148233___all
appall10379743appall
areal55928743are_a_l
areally10411243are_ally
ashfall1343943ashfall
ball66043323__ball
becalm1239203becalm
bedell93610043bedell
beefalo1244083beefalo
befallen1344043befallen
beflag1265883beflag
befool1137713befool
befoul1137253befoul
begalls10319163begalls
behalf14310953behalf
bell66237183be__ll
bewail1189583bewail
call66838673__call
catfall1237393catfall
cecal94619113ceca_l
cecally1459393cecally
cell65031723ce__ll
credal9311673creda_l
crevalle1346163crevalle
deadfall1343313deadfall
deafly13389123deafly
deal56347413de_a_l
deals65435343de_als
dealt65234283de_alt
decal85523233deca_l
decals93717713decals
dedal75719023deda_l
deface123113863deface
defame123212433defame
defang1137753defang
defat95426693defa_t
defats105114553defats
default1147893default
defile105216663defile
deftly1336533deftly
defuel10348933defuel
dell56938203de__ll
derail74218813derail
desalt7518313desalt
detail74516433detail
dewfalls1543073dewfalls
drywall1443653drywall
earl45838143_e_arl
egal55119433_ega_l
ell36735683_e__ll
email74715103_email
evenfall1492943evenfall
exalt123018533_exalt
eyeball1245063eyeball
fail74840243__fail
falls85727653__falls
falx147120783__falx
farl76338553__farl
feal713940423fe_a_l
fecal105119213feca_l
fell76833073__fell
female11310553female
feral85424653fera_l
ferals94216643ferals
fetal85623373feta_l
fill75540203__fill
fireball13127263fireball
firehall14105623firehall
firewall14125933firewall
full75229153__full
gall56335993__gall
hall75741163__hall
heal75645693he_a_l
heals85733463he_als
hell75637893he__ll
hemal104419803hema_l
herald10311343herald
icefalls1344253icefalls
infalls1038943infalls
infill938413infill
inwall938343inwall
ireful948713iref_ul
irefully1445943irefully
jell117125873je__ll
jezail2234643jezail
lall45531313__lall
leal46043273le_a_l
leally94012613le_ally
legal65715943lega_l
legally1138133legally
legals73412733legals
mall64639373__mall
meal65643173me_a_l
meals75933383me_als
mealy104422183me_aly
medal86221333meda_l
medals94218063medals
mell64935613me__ll
mesally12119793mesally
metal75427383meta_l
metals84520893metals
offal1136243offa_l
offals1235893offals
outfall1039683outfall
overall10411083overall
pall65039343__pall
peal68648103pe_a_l
peals75235493pe_als
pearl75324463pe_arl
pedal86022503peda_l
pedalo93811153pedalo
pedals94316033pedals
penal75228373pena_l
penally121111773penally
petal76526893peta_l
petals84719813petals
pitfall1245823pitfall
pratfall1344153pratfall
prebill1138803prebill
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefile123413183prefile
prepill1147583prepill
presale9416353presale
presell939303presell
pretell938243pretell
prevail1238243prevail
raffle123910703raffle
rail46147763r__ail
rainfall1144483rainfall
rale45050563r__ale
rally84725903r__ally
ramal74622253rama_l
ratal55025113rata_l
ratals64219583ratals
reach105123883re_ach
react74634333re_act
read55942533re_a_d
readd74617133re_add
reads64835273re_ads
ready94821503re_ady
realer63528593re_aler
reales64934123re_ales
realia6314593re_alia
reallot7312133re_allot
realms84913493re_alms
realty92713693re_alty
ream65841613re_a_m
reams75729623re_ams
reap65934743re_a_p
reaps75626193re_aps
rear45644553re_a_r
rearm75923573re_arm
rears54739653re_ars
reata54225393re_ata
reavail1035643reavail
reave84528023re_ave
rebait8320403rebait
rebar75420193reba_r
rebars84019833rebars
rebate84424113rebate
rebato83714683rebato
rebel73421293re_bel
rebels84518133rebels
rebills93510623rebills
reboil83814683reboil
recalled11310803recalled
recaller1039323recaller
recane83022873recane
recant83228683recant
recap95718023reca_p
recaps103615733recaps
recast83422773recast
reclad9311873reclad
recoal84117983recoal
recoals94214633recoals
recoil84016723recoil
rectal84418143rectal
rectally1339713rectally
redact9419043redact
redan66125013reda_n
redans75421023redans
redate74124683redate
reddle83815913reddle
redial74923113redial
redials84416883redials
redly94217203re_dly
redpoll1045043redpoll
redrill857893redrill
redtail858713redtail
reearn6612143reearn
reefable1339533reefable
reel45240533re__el
reels55333263re_els
ref66053293ref___
refaced133713573refaced
refaces123216743refaces
refalling132010423refalling
refect114319333refect
refed93921923ref_ed
refeed104717623refeed
refeels10379693refeels
refelled122810173refelled
refer84822143ref_er
refers93921083refers
reffed134712513reffed
refiled114318653refiled
refiles104122423refiles
refilled12278673refilled
refilms12347503refilms
refind104717073refind
refine95225693refine
refire95419473refire
refit84230063ref_it
refits94017653refits
refix155212483ref_ix
reflags1156953reflags
reflate103516263reflate
reflet94024233reflet
reflew12389453reflew
reflex16359513reflex
reflow12379653reflow
reflux16315413reflux
refolds11298953refolds
reform11312723reform
refract121311603refract
refrain10310043refrain
reframe1239393reframe
refry114412463ref_ry
refs75732243ref__s
reft75141273ref__t
refuels10399523refuels
refuge105312613refuge
refund104810303refund
refusal1056893refusal
refusals1164913refusals
refuse94817513refuse
refutal1046943refutal
refutals1165503refutals
refute95515703refute
regain74517763regain
regaled93615963regaled
regaler83814623regaler
regales83520793regales
regalia839223regalia
regard85215773regard
regave104713383regave
regild8149773regild
regilt71217493regilt
regnal74812933regnal
reguli738143reguli
rehab10312443reha_b
rehabs1139023rehabs
rehang1039823rehang
rehash1237433rehash
reheel93610823reheel
relabel938163relabel
relace83122153relace
relaid75518443relaid
reland75920433reland
relate64033633relate
relax124817803rela_x
relay84424673rela_y
relays94316753relays
rely75428953re__ly
remade94316983remade
remails94714563remails
remain85919863remain
remake124016113remake
reman75730153rema_n
remand95618963remand
remans84823003remans
remap95418103rema_p
remaps105012873remaps
remark123512373remark
remate84428683remate
remelt85123123remelt
remold93412973remold
renails74917263renails
rename82718813rename
rental63922033rental
rentals74017483rentals
reoil55321183re_oil
reoils64516873reoils
repack142412163repack
repaid94716323repaid
repair84011463repair
repand95316063repand
repanel939963repanel
repark123511713repark
repass84114703repass
repast83520633repast
repave114813873repave
repay104818453repa_y
repays113813973repays
repeal84718293repeal
repeals94014533repeals
repel74921403re_pel
repels84318763repels
replan83215823replan
replay113412923replay
reply104015853re_ply
repolls939053repolls
rerack122513163rerack
reran57329103rera_n
rerolls739943rerolls
resaid74517083resaid
resails74616743resails
resales74724903resales
resat55139683resa_t
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
rescale93215483rescale
reseal64819653reseal
reseals73917683reseals
resells73313203resells
resile64627673resile
resold73915363resold
resole64624183resole
respell947023respell
result6318223result
retable91820403retable
retack122612823retack
retag63618413reta_g
retags73414303retags
retails74718973retails
retain64523283retain
retake104718533retake
retape83917683retape
retard75018933retard
retax124517973reta_x
retells73211523retells
retial64724993retial
retile65929673retile
retold73013753retold
retool63914483retool
retral64419743retral
retrally11310523retrally
revalue1038153revalue
revamp1336013revamp
reveal94115063reveal
reveals103812733reveals
revel84423163re_vel
revels94220573revels
revile94921613revile
revolt9316223revolt
rewake135218463rewake
rewan85623663rewa_n
reward106017643reward
rewarm115913493rewarm
rewash1237673rewash
rewax155713923rewa_x
reweld103711113reweld
rial45938103r_ia_l
rials55026673r_ials
ribald9209293ribald
rifely123710033rifely
riffle124210233riffle
rifle85518333rif_le
rill45140913r__ill
rival85216503riva_l
rivals94213183rivals
riyal84413433riya_l
riyals94111083riyals
robalo838933robalo
rockfall1743403rockfall
roll46331653r__oll
royal85014703roya_l
royally13157733royally
royals93711263royals
rueful948203ruef_ul
ruefully1445223ruefully
ruffle124111673ruffle
ruffly15336673ruffly
rugal65916093ruga_l
rural55821173rura_l
rurally1038303rurally
sall44544683__sall
scall74420373_scall
seal45654373se_a_l
seals54839703se_als
seawall1046203seawall
sell45840613se__ll
sepal77723003sepa_l
sepals85217383sepals
serail64222673serail
seral56336383sera_l
setal56430903seta_l
shall85024053_shall
small74016263_small
spall74919303_spall
squall1538003squall
stall54722353_stall
tall47240213__tall
teal45546503te_a_l
teals56234133te_als
tell44934703te__ll
tenail64516113tenail
tepal76319583tepa_l
tepals85415043tepals
thrall93810293thrall
trefah1235093trefa_h
trefoil1066063trefoil
trehala1045963trehala
trenail7410813trenail
trevally1446343trevally
ureal56722683ure_a_l
veal76936813ve_a_l
veals84926193ve_als
vealy115817773ve_aly
venal85523213vena_l
venally13119563venally
wall76236103__wall
weal75838683we_a_l
weald95615023we_ald
weals85428743we_als
well75832043we__ll
yell76028323ye__ll
zeal135530333ze_a_l
zeals145320853ze_als

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164715.32621163.3
3Display Results4714710.1563019.2
 (SQL Overall)1786914715.87230431.0
 
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.