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

269 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
aliment931670(None) 
ailment9314231ailment
aliments10311091aliments
ailments1039432ailments
alien56425582ali_en_
aliens65619212ali_ens
alignment1246372alignment
alimental1155862alimental
alimented1245312alimented
alimony1236012alimony
alinement1149102alinement
ament76036542a__ment
augment10910202augment
bailment1249182bailment
clement11313772clement
client8316342cli_ent
element9317802element
lament85024942_lament
limen75426032_limen_
limens84618032_limens
loment84021472_loment
raiment9315412raiment
salient7419762sali_ent
abetment1248233abetment
abluent939623abluent
absent84016993a_bsent
abutment1247223abutment
accent105116263a_ccent
accident13148183accident
acumen1049013acumen_
acumens1136953acumens
adamant101110443adamant
admen84516183a_dmen_
advent102613753a_dvent
affixment2443883affixment
agent65829643a__gent
aidmen92610373aidmen_
aimed85626053a_ime_d
aimer75926823a_ime_r
aimers84621913a_imers
aiming94320833a_iming
airest63825263a_irest
airmen82612353airmen_
alameda1035493alameda
alant55742293al__ant
albeit8314343al_beit
albumen1135243albumen_
albumens1244143albumens
alert54740653al__ert
alienate8311553ali_enate
aliened81011743ali_ened
alienee71013153ali_enee
aliener71011193ali_ener
alienist8411993ali_enist
alienly1037503ali_enly
alienor7116303ali_enor
alight103816863ali_ght
alightment1693953alightment
align65016503ali_gn_
aligned9128553aligned
aligner8108303aligner
alignments1344633alignments
aligns75312953ali_gns
alike95523963alike__
alimentary1553983alimentary
alimenting1344503alimenting
aline57243153ali__ne
alined75221403aline_d
alinements1247133alinements
aliner65621983aline_r
aliners74717723aliners
alines65735223aline_s
alining81917043alining
aliped95414283alipe_d
alipeds10386793alipeds
aliquant1746073aliquant
aliquot1646493aliquot
alist56136783ali__st
alit46155693ali___t
alive85722513alive__
aliyot93611713ali_yot
alkanet113714433alkanet
alkene104114003al_kene
allotment1146333allotment
alme65832163al_me__
almeh106214553al_me_h
almehs11619493al_mehs
almes75126543al_me_s
almner85710723al_mner
almond91410433al_mond
almost81014433al_most
almsmen1144583almsmen_
alumin8513543alumin_
alumina9510053alumina
alumine9412693alumine
alumins9512983alumins
alumna857343alum_na
alumni856753alum_ni
ambient11310083ambient
amen66733153a__men_
amend85717753a__mend
amens75624843a__mens
aments85219803a__ments
ancient9514733ancient
anent54931843a__nent
anime75423203anime__
animes84719593anime_s
animist93815173animist
ardent73022613a_rdent
argent74023663a_rgent
argument1158903argument
aridest8316143aridest
arisen65316793arisen_
armament1249633armament
armet76739453a_rme_t
arpent84822093a_rpent
ascent84519653a_scent
ashmen1168173ashmen_
assent65119953a_ssent
attent62818323a_ttent
audient8312303audient
augments1137833augments
averment13311603averment
axemen1547493axemen_
axmen145112273a_xmen_
bailments1346463bailments
balmiest124110993balmiest
basement12311493basement
blent76230953bl__ent
blimey13468453blime_y
calamint12315133calamint
calmest11312343cal_mest
calumet11313293calume_t
casement12311953casement
cement103321663_cement
claimant1247483claimant
clamant11312433clamant
clients938093cli_ents
clime95720893clime__
climes104720003clime_s
comment1310317703comment
daimen92210573daimen_
dement93825143_dement
diligent1048033diligent
diluent8310263diluent
diriment11410743diriment
easement10414163easement
elements10312173elements
elint55436473eli__nt
elmiest9310743elmiest
eloinment1147253eloinment
eluent6315483el_uent
eminent9313843eminent
evident1139993evident
exigent1539513exigent
ferment12315573ferment
figment1379743figment
filament13410033filament
fitment12710303fitment
flamen115215993flamen_
flamens124611063flamens
fliest94718423fli_est
flint87333503fli__nt
fluent9313933fl_uent
flymen14387773flymen_
foment113718303_foment
galivant1247083galivant
garment10315233garment
glime85620193glime__
glimed105312283glime_d
glimes94717523glime_s
gliming113310133gliming
glint66830183gli__nt
habiliment1753563habiliment
hardiment1546063hardiment
hutment1239173hutment
lambent113711303lambent
laments94314853_laments
lamest84722763_lamest
latent64124303_latent
lawmen11308593lawmen_
laymen113010843laymen_
lent46360533_l__ent
licente91210893_licente
lien45339803_li_en_
liens56525503_li_ens
ligament1149303_ligament
liken911818843_liken_
likens105613703_likens
likest104914383_likest
liman75921603_liman_
limans84816303_limans
lime66244933_lime__
limed85426803_lime_d
limes75636503_lime_s
limey104721043_lime_y
limeys11429273_limeys
limiest93716103_limiest
limina83514493_limina
liming94021233_liming
limit73126333_lim_it
limn66527693_lim_n_
limned94811473_limned
limner84112863_limner
limns75718393_lim_ns
limpest113712313_limpest
limpet103518633_limpet
linen55728723_linen_
linens64818393_linens
lineny94011433_lineny
liniment1049533liniment
linnet6419413_linnet
lint416266233_li__nt
lisente71210703_lisente
liven85021733_liven_
livens94314893_livens
livest95315733_livest
lomenta92710133_lomenta
loments93413473_loments
lucent8313823_lucent
lumen75220903_lumen_
lumens85013973_lumens
mailmen1137273mailmen_
malmiest123211023malmiest
moment103319683_moment
muniment1248943muniment
oddment1145923oddment
oilmen848313oilmen_
orient6322533ori_ent
orpiment1247973orpiment
paliest93021603pali_est
palimony1544303palimony
palmiest123212023palmiest
parament12415393parament
parliament1454643parliament
patient9617073pati_ent
pavement1549443pavement
payment14310703payment
pediment13411393pediment
pigment12510733pigment
pimento1157223_pimento
pliant83918823pli_ant
raiments1039903raiments
regiment114414053regiment
rident7520193_rident
rudiment1147663rudiment
salients839563sali_ents
sapient9415333sapi_ent
sarment9318763sarment
sediment11411103sediment
segment10312563segment
shipment15217593shipment
silent64125843_silent
sliest66621943sli_est
slime74925753slime__
slimed94915123slime_d
slimes84722043slime_s
slimiest10310743slimiest
sliming102913953sliming
slimmest1235903slimmest
talent6323323tal__ent
taximen1644923taximen_
torment9316173torment
trident8314193trident
valiant10314623vali_ant
varment12313243varment
vimen104114753_vimen_
weldment1445823weldment
wisent93516343_wisent

Search took 9 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 Limit1340272698.45315855.6
3Display Results2692690.0962802.1
 (SQL Overall)1786912698.68920565.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.