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

468 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
aviates1031306(None) 
aviate9315201aviate_
aviated11310261aviated
abates85825032a_bates
ablates92416902ablates
aerates74627492aerates
agates76121342a_gates
agitates9310882agitates
agnates82813192agnates
alates64833972a_lates
aliases7914492aliases
amirates101114792amirates
animates101316422animates
annates72415422annates
avgases11106312avgases
avians93711562avia_ns
aviaries1139782aviaries
aviatic1239242aviatic
aviator10229662aviator
aviators11169902aviators
aviatress1242432aviatress
axites134913832axi_tes
caviares1337992caviares
cavitates14168962cavitates
deviates12312732deviates
evites94916472evi_tes
labiates101011512labiates
navigates1345872navigates
obviates1345152obviates
opiates9312142opiates
radiates92415292radiates
satiates8314632satiates
savates10312952sav_ates
vacates12312832vacates
variates111214982variates
abases85720773a_bases
abate76627843a_bate_
abated95918453a_bated
abater85518123a_bater
abaters95115203a_baters
abatis84317933a_batis
abdicates1448153abdicates
abides94719893abi_des
abioses9311493abioses
ablate82219213ablate_
ablated102513443ablated
abrades10312073abrades
abwatts1233403abwatts
acetates102013063acetates
achiotes1339003achiotes
acierates11310813acierates
activates1449683activates
actuates10310313actuates
acuate8315633acuate_
acutes83917723a_cutes
acylates1339743acylates
adages8412953a_dages
addaxes1634573addaxes
adits66523713adi_t_s
adnate72913483adnate_
adulates9311913adulates
advices13136933advi_ces
advisees12154133advisees
advises11138973advi_ses
advocates1545883advocates
aerate64830553aerate_
aerated85322373aerated
agapes95212413a_gapes
agate66525153a_gate_
agaves104611513a_gaves
agemates111110023agemates
agisted938203agisted
agists75713173agist_s
agitas7310593agi_tas
agitate8312063agitate_
agitated1038413agitated
agnate73314883agnate_
agrafes1137523agrafes
aides65336603a_i_des
airdates939723airdates
airted74214503a_irted
airths95414253a_irths
airts55626343a_irt_s
aisles64721143a_isles
aits46355533a_i_t_s
alate55340333a_late_
alated75625153a_lated
albatas938373albatas
albites9313203albites
alcades101011473alcades
alginates10310123alginates
alias55834603alia__s
alibies9313323alibies
alidades1037003alidades
alienates9310683alienates
alines65735223ali_nes
alkanes113812933alkanes
alleviates1344943alleviates
amazes175613473a_mazes
ambages1269623ambages
amiantus1044383amiantus
amias75831473amia__s
amices105018013ami_ces
amidases1136653amidases
amides95722663ami_des
amies76837693ami__es
amines84727983ami_nes
amirate91115953amirate_
amities9317383amities
amniotes1036603amniotes
andantes9310853andantes
animate91617213animate_
animated111612373animated
animater101512393animater
animaters11129973animaters
animes84719593ani_mes
anises64826693ani_ses
anlaces92313733anlaces
anlages82414113anlages
anlases72514903anlases
ansate64517863ansate_
ansated84214003ansated
antes56334323a__ntes
apiaries10312733apiaries
apices104916263api_ces
aplites9314933aplites
arames84622573a_rames
arbutes939703arbutes
arcades101113193arcades
aretes64425353a_retes
arhats9312973arhat_s
arias55438023aria__s
ariettes8411353ariettes
arises65233803ari_ses
aristas7413523aristas
aristos7312373aristos
arrases71214543arrases
artistes83213343artistes
ascites9312603ascites
asides75118873asi_des
aspirates1139613aspirates
ates45047923___ates
atlantes838553atlantes
atlases72410643atlases
atlatls744773atlatls
aubades1038753aubades
augites8312183augites
aurate64426473aurate_
aurated83817793aurated
availed1135973availed
avails939693av_ails
avatar937523av_atar
avatars1036443av_atars
avenges1157543avenges
avenses1049643avenses
avenues1057183avenues
averages1249183averages
averted112211613averted
averter102410553averter
averters11249513averters
averts95715243avert_s
aves76142603av___es
avgas96912133avga__s
avgasses1284193avgasses
avian84616053avia__n
avianizes2145553avianizes
aviarist11410113aviarist
aviary12338413avia_ry
aviating12311023aviating
aviation11312743aviation
aviations12311553aviations
aviatrices1543163aviatrices
aviatrix1842143aviatrix
aviatrixes2042093aviatrixes
avidins11349003avidins
avidities13107613avidities
avidness1246113avidness
avigator12236773avigator
avigators13177093avigators
avions94114393avi_ons
avisos95410483avi_sos
avocets1235453avocets
avosets1036663avosets
avulses1035433avulses
awaited1146963awaited
awaiter1057443awaiter
awaiters1146643awaiters
awaits96411953await_s
awakes135012473a_wakes
axises134413993axi_ses
axite125218253axi_te_
azides165113803azi_des
azines155517073azi_nes
azotes154312223a_zotes
barites94322333bari_tes
bates75846343__bates
batistes1039713batistes
berates94126873berates
biases84618433_biases
bites75641173_bi_tes
blites84721213bli_tes
bloviates1484543bloviates
boites84322703boi_tes
borates94823013borates
califates14310113califates
capiases1239253capiases
carates95630613carates
caseates10313713caseates
cates75951893__cates
caudates11310263caudates
caveated1439133caveated
caveats1239803caveat_s
caviare1238373caviare_
caviars1238623cavia_rs
cavies114525003cavi__es
cavitate13159833cavitate_
cavitated15177353cavitated
cavities131412613cavities
cerates95428253cerates
ciliates10413453ciliates
cites74435593_ci_tes
climates12311973climates
comates114123643comates
craniates11310653craniates
crates85736063_crates
creates95225203creates
curates95323833curates
dacites101114593daci_tes
dates65639153__dates
davies105020513davi__es
davits104012363davi_t_s
debates103718533debates
delates83526283delates
derates84028893derates
deviate11312713deviate_
deviated13311043deviated
dilates83220663dilates
dites66339153_di_tes
donates83217223donates
elates65032363_elates
elites66027123eli_tes
eluates72014683eluates
eluviates1246103eluviates
emaciates1347883emaciates
emirates101214853emirates
enates64026433_enates
epilates10313503epilates
equates162012323equates
eradiates102010783eradiates
ergates8314493ergates
estates74520183estates
evades1039023ev_ades
evicted1337243evicted
evictee1248103evictee
evictees1344583evictees
evicts11368553evict_s
evinces1237803evinces
evite85317683evi_te_
evited104013143evi_ted
expiates17810213expiates
exuviates1945373exuviates
fates85139233__fates
fiats85324483_fiat_s
filiates11412663filiates
fixates1737393fixates
flites95122443fli_tes
folates103218453folates
foliates11412753foliates
frigates12310933frigates
frites94922483fri_tes
gallates92815533gallates
gates65939513__gates
gavages1237683gav_ages
gavials1136603gavia_ls
gavottes1274183gavottes
gelates83219593gelates
gites65630183_gi_tes
glaciates1267353glaciates
grates75429893_grates
gravitates1444843gravitates
gyrates113610263gyrates
halites103221193hali_tes
hamates122917683hamates
hates86742573__hates
hiatus938223_hiatus
humates122813193humates
ideates8313733ideates
imitates10310503imitates
ingates82716913ingates
inmates92715783inmates
invites103915813invi_tes
iodates8312903iodates
ivies84215763ivi__es
kalifates1646133kalifates
karates115617473karates
kites95432543_ki_tes
kvases13467103kv_ases
labiate91313573labiate_
labiated11109303labiated
lactates10311233lactates
laminates112712903laminates
lapidates1247143lapidates
lariated91212063lariated
lariats7615053lariat_s
lavages1138603lav_ages
lavishes1457403lavishes
legates82917683legates
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
lianes63819323_lianes
ligates82318383ligates
locates93218813locates
luxates1436973luxates
lysates10317473lysates
magnates11511613magnates
malates93522613malates
maleates103316343maleates
mandates11314093mandates
marinates112516383marinates
mates75251363__mates
mavies114923193mavi__es
mavises122812993mavi_ses
mediates112814063mediates
metates92720013metates
mites75141803_mi_tes
muriates10312083muriates
mutates92215793mutates
myiases1235493myiases
naiades838213naiades
naivetes1145113naivetes
narrates8312763narrates
nates55238333__nates
navettes1136613navettes
navies95218623navi__es
navigate1246073navigate_
navigated1445483navigated
negates83215843negates
nidates8311893nidates
nites55736343_ni_tes
notates72817483notates
nutates73214973nutates
oblates91913243oblates
obviate1235783obviate_
obviated1444563obviated
oleates7417833oleates
opiate8513463opiate_
opiated1039483opiated
orates64328613_orates
ovate84214393ov_ate_
ovines94614343ovi_nes
ovulates1148523ovulates
oxidates1636333oxidates
paginates123111363paginates
palates93624943palates
palliates11311033palliates
palpates122613063palpates
parietes10714543parietes
pates76047893__pates
patinates113814693patinates
patriates11311363patriates
pavanes123612653pav_anes
pavises125315493pavi_ses
pavisses13397103pavisses
penates93321603penates
pirates93020333pirates
pistes85325633_pistes
plates85432243_plates
pointes93216753pointes
prates84633163_prates
primates121515933primates
privates131812373privates
pupates113311433pupates
quintes164114713quintes
radiate83416313radiate_
radiated102512593radiated
radicates12412073radicates
rates55352013__rates
ratites74920683rati_tes
ravages1139403rav_ages
ravigotes1343513ravigotes
ravines104220233ravi_nes
ravishes1478043ravishes
rebates95123183rebates
redates83423873redates
relates73731433relates
remates93827113remates
riatas63915093_riatas
rites54442553_ri_tes
rivages1138873rivages
rotates72819773rotates
ruinates8311883ruinates
salivates1239293salivates
samites93118713sami_tes
sanitates9611733sanitates
sates54949323__sates
satiate7315403satiate_
satiated9311603satiated
savages1139973sav_ages
savate9313783sav_ate_
savines104417633savi_nes
sedates83418043sedates
senates73322613senates
seriates82620673seriates
sites56045433_si_tes
sixtes133612403_sixtes
skates104219403_skates
skites104418043ski_tes
slates64934063_slates
smites83921923smi_tes
solates73523853solates
spates85028173_spates
spites84127333spi_tes
states64337083_states
striates83417083striates
suites63727403sui_tes
tannates81911953tannates
tates55444983__tates
taxites1449673taxi_tes
triages82613793triages
unites65024853uni_tes
updates10329793updates
uprates93814863uprates
urates65027763_urates
urinates8314133urinates
vacate11314553vacate_
vacated1349353vacated
vales85434263_v_ales
validates1338243validates
valuates112811203valuates
vanes85130973_v_anes
variate101316433variate_
variated121211393variated
vases84626263_v_ases
vats76841743_v_at_s
vatus86114643_v_atus
vialed105112593_vialed
vials85822383_via_ls
viands1047813_viands
viatic11311453_viatic
viator93211833_viator
viatores11257693_viatores
viators102712023_viators
vibes104719953_vi_bes
vibrates132210613_vibrates
vices105725533_vi_ces
vies75238623_vi__es
vines85137643_vi_nes
violates11311193_violates
vires84529683_vi_res
virgates1237923_virgates
virtues10338023_virtues
virtus94310143_virtus
visages1138693_visages
vises84427773_vi_ses
vistas94513273_vistas
vitae84217633_vitae_
vitals94514303_vitals
vitiates112311433vitiates
vittles103211113_vittles
vivaces1536413_vivaces
voltes94915583_voltes
votes84627083_v_otes
wavicles1633783wavicles
wavies125019843wavi__es
whites123919883whi_tes
wites85536963_wi_tes
writes94420333wri_tes

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.436409841.7
2DLD Change Limit1340274686.31321230.3
3Display Results4684680.1862516.1
 (SQL Overall)1786914686.93525766.5
 
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.