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

281 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
afreets103701(None) 
afreet9315151afreet_
affects1535392affects
afrits9311902afr_its
agrees74915322agree_s
amreeta945162amreeta
amreetas1044272amreetas
aretes64425352a_retes
armets84918352a_rmets
arrests73312682arrests
fleets96915062_fleets
freers94717302_freers
frees86131392_free_s
freest95318282_freest
frets85523402_fr_ets
greets75117422_greets
streets73312612streets
abets75621673a__bets
abreacts1245633abreacts
abreast9311273abreast
absents93510723absents
accents113511233accents
accepts13356353accepts
accretes1238113accretes
ackees124914583ackee_s
acres76327763acr_e_s
adeems946333a_deems
adepts9117103a_depts
advects13276013advects
advents11309473advents
adverts11308513adverts
aerates74627493aerates
aeries64737783aerie_s
aeriest73924053aeriest
affect1448903affect_
afferents1546013afferents
afforests1543733afforests
affronts1444163affronts
afresh1255503afr_esh
afrit8323173afr_it_
afters94717073af_ters
agents74816293a_gents
aglets73915683a_glets
agree65226033agree__
agreed84712503agree_d
aiglets84012913aiglets
aigrets82810533aigrets
airers64922313air_ers
airest63825263airest_
airiest74221013airiest
airless73712043airless
airts55626343air__ts
akees96119243a_kee_s
alerts64418223a_lerts
allees64521483allee_s
ambeers11428923ambeers
ameers84015573a_meers
aments85219803a_ments
amulets939923amulets
anklets114310413anklets
aorists74215833aorists
applets115710063applets
apres75426403apr_e_s
ardebs937013a_rdebs
areas55935773a_r_eas
arecas84817443a_recas
arenas65021993a_renas
arenes64928393a_renes
arepas85515703a_repas
ares45871023a_r_e_s
arete56031353a_r_ete
argents84014853argents
argots74116033a_rgots
arhats9312973a_rhats
ariels65119373a_riels
arles56735743a_rle_s
armers85520273a_rmers
armet76739453a_rmet_
armlets94610063armlets
armrests1055383armrests
arpens84814823a_rpens
arpents93613083arpents
arrears738843arrears
arrest63722633arrest_
arses55733873a_rse_s
artels66216233a_rtels
arts49650263a_r__ts
ascents93812553ascents
aspects1146743aspects
assents74512223assents
asserts74311793asserts
assets65617663a_ssets
attests7278813attests
auklets11298573auklets
aureate72515283aureate
aures55137093aur_e_s
aureus65314883aur_eus
aurists74615783aurists
averts95715243a_verts
avocets1235453avocets
avosets1036663avosets
axseeds1533393axseeds
barbets114915843barbets
barrets94917103barrets
beets76131443__beets
befrets1237613befr_ets
berets85822523ber_ets
boreens9310403boreens
breeds94914883_breeds
breeks125310793_breeks
brees75632553_bree_s
brents84717273_brents
brevets12519393_brevets
burets84321263bur_ets
burnets93813263burnets
careens94514703careens
careers95218783careers
carets85330773car_ets
carnets93918403carnets
carpets113915333carpets
cermets1139713cermets
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
creeds94714773_creeds
creeks124812923_creeks
creels84416943_creels
creeps104213623_creeps
crests85218703_crests
cruets85314953_cruets
curets84922343cur_ets
curvets12399913curvets
deets65330243__deets
directs102710263directs
drees65628523_dree_s
effects1535283effects
egrets72712243egr_ets
erects84116183_erects
facets116316653_facets
fakeers14446673fakeers
fanjets1734803fanjets
farcers124713443farcers
farces115223323farce_s
fardels11389893fardels
farers95924053far_ers
fares85852873far_e_s
farfels13348213farfels
farles96025783farle_s
farmers124315263farmers
farness102912203farness
farts88336843far__ts
faucets12578443faucets
feats86432753_f_eats
feebs106112683_f_eebs
feeds94921143_f_eeds
feels85223043_f_eels
fees76450603_f_ee_s
feet75352213_f_eet_
felts85324543_f_elts
feres86038183_fere_s
ferrets103111393ferrets
fests85828043_f_ests
fetes85630143_f_etes
fets75345943_f__ets
filets94718953_filets
fleers96015793_fleers
flees85828753_flee_s
fleet85932333_fleet_
forests104114953forests
forgets113813793forgets
frats86829673_fr_ats
freaks134713063_freaks
free75940183_free__
freed95223543_free_d
freely12310963_freely
freer86021243_free_r
freeze18349513_freeze
freezes193310353_freezes
freres94716173_freres
freshets14298673_freshets
fret75845043_fr_et_
fretty1249223_fretty
friers94718933_friers
fries85535603_frie_s
frites94922483_frites
frits86129103_fr_its
fritts94613193_fritts
froes86126693_froe_s
fronts94415793_fronts
frosts94214623_frosts
fruits94512493_fruits
fryers125710973_fryers
fumets114311813_fumets
gargets94614573gargets
garnets84115403garnets
garrets84413623garrets
gerents82612923gerents
gleets75315053_gleets
gorgets94711783gorgets
greats76318393_greats
greeds84314283_greeds
greens75716873_greens
grees65132473_gree_s
greet65835323_greet_
gurnets84010793gurnets
haffets1636053haf_fets
hairnets1195633hairnets
hareems12428203hareems
hirees95117293hiree_s
hornets104113553hornets
jereeds15326393jereeds
keets95123483__keets
kreeps12427413_kreeps
labrets939363labr_ets
larees65323113laree_s
leets54927123__leets
markets133314033markets
meets74224613__meets
moreens939963moreens
offsets1333503offsets
parents93418123parents
pargets105215193pargets
preens85020113_preens
prees75937173_pree_s
presets94216423_presets
prests84021263_prests
purees84721683puree_s
reeds65430903__reeds
reefs85121663__reefs
reeks94124033__reeks
reels55333263__reels
rees45364193__ree_s
reest54938093__reest
reests64618893__reests
regreets9287853regreets
relets64025673__relets
remeets93712413remeets
rents55935183__rents
rerents73319423rerents
resets65427613__resets
rests54935873__rests
rets45352563__r_ets
revets94022173__revets
rewets94617213__rewets
sarees65329943saree_s
screeds106210293screeds
screens95212183screens
screes85023973scree_s
sheets93918503_sheets
sirees64624583siree_s
skeets104513253_skeets
sleets64318873_sleets
sorbets93012513sorbets
sprees85620643spree_s
streeks11378713streeks
streels73811343streels
street64125773street_
sweets94214433_sweets
targets84314223targets
tercets93512443tercets
terrets72913583terrets
threats104311673threats
threeps12687043threeps
threes97117323three_s
treats64821693_treats
treens65317873_treens
trees55835763_tree_s
trets55928023_tr_ets
trevets10499973_trevets
tureens7289873tureens
turrets73010673turrets
tweets94210103_tweets
unfrees1048643unfree_s
unreels7258313unreels
unrests7229463unrests
varlets10411573varlets
versets103913103versets
vervets13419753vervets
weets85427723__weets
worsets105512843worsets
wrests95313083_wrests

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272816.59620319.4
3Display Results2812810.0933021.5
 (SQL Overall)1786912817.09225196.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.