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

312 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
aigrets8281053(None) 
aiglets84012911aiglets
aigret73720021aigret_
aggress935592aggress
aglets73915682a_glets
agrees74915322a_grees
aiglet74224192aiglet_
aigrette946832aigrette
aigrettes1046392aigrettes
airers64922312ai_rers
airest63825262ai_rest
airts55626342ai_r_ts
cigarets1145472cigarets
digress938322digress
egrets72712242_egrets
giglets93211552giglets
piglets103311792piglets
regrets83212922regrets
signets83311502signets
tigress836092tigress
wiglets113411422wiglets
abets75621673a__bets
aborts84916183abor_ts
accrete1137843accrete
accretes1238113accretes
acres76327763a_cre_s
actress948533actress
address956103address
addrest958633addrest
adorers84411733adorers
adores74420723adore_s
adverts11308513adverts
afreets1037013afreets
afrits9311903a_frits
agates76121343a_gates
agents74816293a_gents
agers65027853a_g_ers
ages55844593a_g_e_s
aggers85817793a_ggers
aggies83515513aggie_s
aggros836553aggr_os
agists75713173a_gists
aglet65534143a_glet_
agree65226033a_gre_e
agreed84712503a_greed
agrias74315393a_grias
agues64919053a_gue_s
aiders74524633ai_ders
aides65336603ai_de_s
aidless83612073aidless
ailments1039433ailments
aimers84621913ai_mers
aimless93610813aimless
airbus848343ai_rbus
aircrews13122813aircrews
aired66032923ai_re_d
airer54927893ai_re_r
airiest74221013airiest
airless73712043airless
airns55521033ai_r_ns
airs46447423ai_r__s
airt45757783ai_r_t_
airted74214503ai_rted
airth85621023ai_r_th
airths95414253ai_rths
aisles64721143aisle_s
aits46355533ai___ts
aivers94822323ai_vers
alerts64418223aler_ts
alights113211433alig_hts
aligners9117573aligners
amulets939923amulets
ancress978613ancress
angels74416173ang_els
angers75222543ang_ers
anglers84014823anglers
angles74426703angle_s
angriest9310253angriest
angsts738863ang_sts
anklets114310413anklets
antres65021003antre_s
applets115710063applets
apres75426403a_pre_s
areas55935773a__reas
ares45871023a__re_s
arete56031353a__rete
aretes64425353a__retes
argents84014853argents
argles75218483argle_s
argots74116033arg_ots
arguers8489033arguers
argues74516413argue_s
armets84918353a_rmets
armlets94610063armlets
armrest9310163armrest
armrests1055383armrests
arrest63722633a_rrest
arrests73312683a_rrests
arts49650263a__r_ts
asserts74311793asserts
assets65617663a_ssets
attrits7310613attrits
augers73818703aug_ers
aughts104710243aug_hts
augites8312183augites
augments1137833augments
augurers9114813augurers
auklets11298573auklets
aures55137093a_ure_s
aureus65314883a_ureus
averts95715243aver_ts
avocets1235453avocets
avosets1036663avosets
azures15510183azure_s
baguets1037483baguets
barrets94917103barrets
befrets1237613befrets
begets96215523beg_ets
beignets11155373beignets
berets85822523_berets
bidets95215533bi_dets
biggest1138143biggest
biggety1434433biggety
bights124417963big_hts
bigness1038193bigness
bigots95015133big_ots
billets94516153billets
burets84321263_burets
cabarets12268463cabarets
carets85330773_carets
cigaret10413003cigaret_
cires74932913ci_re_s
civets115212543ci_vets
clarets94111103clarets
curets84922343_curets
cygnets1333813cygnets
degrees92810723degrees
diets66026643di__ets
digest84019623dig_est
digests93610613digests
diggers104413393diggers
dights114016963dig_hts
digits84114533dig_its
diglots9299503diglots
dipnets10109033dipnets
directs102710263di_rects
direst75024243di_rest
dirges84915103dirge_s
dirts66824463di_r_ts
diverts114412033diverts
eaglets84111663eaglets
eagres74014573eagre_s
egress73310433_egress
egret63327313_egret_
eights103618983eig_hts
emigres1037673emigre_s
fairest10412293fai_rest
ferrets103111393ferrets
fibres114312123fibre_s
fidgets12388763fidgets
fights133816553fig_hts
figments1446943figments
figurers12254873figurers
figures11239113figure_s
filets94718953fi_lets
fillets103414753fillets
firers94922683fi_rers
fires85740753fi_re_s
firsts95110923fi_rsts
florets1039853florets
forgets113813793forgets
frets85523403__frets
gadgets10348683gadg_ets
gangrels1094973gangrels
gargets94614573garg_ets
garrets84413623garrets
gets55442483__g_ets
gibbets12417723gibbets
giblets103210423giblets
giglet83920273giglet_
giglots9367863giglots
gigots83911953gig_ots
gigues8129003gigue_s
gimlets10338433gimlets
girts65423623gi_r_ts
goglets9379783goglets
gorgets94711783gorgets
greats76318393__greats
grees65132473__grees
greets75117423__greets
greys96614853__greys
grits65529583__grits
grots65025853__grots
guglets9369693guglets
hairnets1195633hairnets
highest1439563highest
hights133716893hig_hts
hirees95117293hi_rees
hirers94518063hi_rers
hires86134343hi_re_s
hoggets12498323hoggets
imarets9138643imarets
inerts64517023_inerts
ingress838653ingress
inlets63915573_inlets
insets64016133_insets
ires45639283_i_re_s
islets64513083_islets
jiggers164010183jiggers
kinglets13318583kinglets
kismets13306883kismets
labrets939363labrets
langrels9106173langrels
languets987243languets
lazarets1744803lazarets
ligates82318383ligates
ligers75022043lig_ers
lights104519913lig_hts
ligures8269893ligure_s
limpets11329783limpets
linnets739833linnets
litres65220393litre_s
livres94311863livre_s
loggets9378913loggets
magnets10311143magnets
maigre9309163maigre__
midgets113910253midgets
mights123516253mig_hts
migrants1138183migrants
migrate101314173migrate
migrates111112853migrates
millets94216843millets
milreis937323milreis
minarets1048843minarets
minuets9259853minuets
mires75640883mi_re_s
missets94516573missets
mitres83922073mitre_s
nailsets834553nailsets
nidgets9358143nidgets
niggers93111323niggers
nighest11310693nighest
nights104117723nig_hts
nitres65519333nitre_s
nuggets936383nuggets
ogres65818633_ogre_s
ogress7529503_ogress
pargets105215193parg_ets
pickets154314183pickets
piglet93420923piglet_
pigments1337343pigments
pignuts1035613pignuts
pigouts1037593pigouts
pigpens1235503pigpens
piolets93513193piolets
pipets105714773pi_pets
piquets1836603piquets
pugrees10218523pugrees
reglets83512983reglets
regreets9287853regreets
regress82711453regress
regret73723533regret_
rets45352563___rets
riblets93412553riblets
rickets134915093rickets
riggers93613843riggers
rights104019333rig_hts
rillets74216153rillets
ringlets92910233ringlets
rivets94417113ri_vets
secrets9311773secrets
sighers113712183sighers
sights103818013sig_hts
signees83510803signees
signers84714443signers
signet73621153signet_
singlets93611473singlets
sippets113310183sippets
sirees64624583si_rees
sirens65318153si_rens
sires55945373si_re_s
sirrees73410573sirrees
skirrets12244013skirrets
sniglets9276813sniglets
starets73515923starets
tabarets10287233tabarets
taborets10278063taborets
targets84314223targ_ets
terrets72913583terrets
tickets134113683tickets
tigers75616513tig_ers
tights104015853tig_hts
tippets11339373tippets
tires55437493ti_re_s
titres64718933titre_s
trets55928023__trets
turrets73010673turrets
violets102210003violets
vireos94212453vi_reos
vires84529683vi_re_s
waitress1135223waitress
wickets164010943wickets
widgets12318453widgets
wights133315783wig_hts
wigless11359673wigless
wiglet105519153wiglet_
willets104414323willets
winglets12299593winglets
wirers94617893wi_rers
wires86034913wi_re_s
zaires1539703zai_re_s
zibets1737743zi_bets

Search took 7 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.1401276364.3
2DLD Change Limit1340273126.33021173.3
3Display Results3123120.1102836.4
 (SQL Overall)1786913126.58027156.7
 
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.