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

201 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
apollo83718(None) 
apollos946791apollos
abolla8410192abolla
apolog938902apolog
atoll57913922atoll_
atolls65511352atolls
hollo84822162_hollo
polio75722552_polio
poll66332132_poll_
polls74627722_polls
polo66236632_po_lo
aboil72217543aboil_
abollae936943abollae
acold86214933aco_ld
adobo84711593ado_bo
afoul8510193afoul_
ahold94714253aho_ld
aholds10469483aholds
ahull84010313ahull_
aioli5318313aio_li
aiolis6316843aiolis
all36148233a__ll_
allod64418383a__llod
allot54933873a__llot
allow85420663a__llow
alloy85519973a__lloy
alls46740923a__lls
ally76935643a__lly
also46423443a__lso
alto47831263a__lto
amole75724593amo_le
amoles84122193amoles
ampoule11116603ampoule
ampulla1164303ampulla
anally9513503anally
anglo65215373a_nglo
anole55330383ano_le
anoles64827433anoles
aphylly1843353aphylly
aplomb1236203aplomb
apo511142123ap___o
apod78123183apo__d
apodal9289833apodal
apods86316343apo_ds
apogee9312563apogee
apologs1038593apologs
apology1337913apology
apolune945283apolune
aporia8315863aporia
aport75432173apo_rt
apos65433823apo__s
apostle937853apostle
appal95315223appal_
appall10379743appall
appalls11337743appalls
appals104812943appals
appel94615893appel_
appellor1243573appellor
appels104312793appels
apple94517673ap_ple
apples104315763apples
applet105917433applet
apply125111393ap_ply
aptly105111813ap_tly
awol75620673awo_l_
awols84713523awo_ls
axilla13289573axilla
azole145118033azo_le
azoles154614613azoles
boll65634753_boll_
bollox1548743_bollox
bolls75531313_bolls
bolo65535953_bo_lo
brillo84211003brillo
brolly114510853brolly
cello74919583_cello
cholla113911023cholla
cholo105217973cho_lo
collop107312313_collop
colly104926773_colly
coolly114811393coolly
criollo943953criollo
doll56632493_doll_
dollop9259363_dollop
dolls66126923_dolls
dolly96125203_dolly
droll65415403droll_
drolls75312393drolls
drolly105411673drolly
duello756783duello
fillo84319783_fillo
folio83820883_folio
follow124010353_follow
folly115022603_folly
golly95121103_golly
hallo85127553_hallo
hello86522983_hello
hillo84721653_hillo
holla84918493_holla
holloa94914823_holloa
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
holly114824433_holly
hullo84417453_hullo
jello126716273_jello
jolly154517513_jolly
knoll9389603knoll_
knolls10367413knolls
knolly13336133knolly
kolo87026223_ko_lo
lapilli945643lapilli
loll46128383_loll_
lollop8238783_lollop
lolls512121733_lolls
lolly85120663_lolly
moll66735703_moll_
molls75129783_molls
molly105222493_molly
molto75619603_molto
napoleon1042803napoleon
niello636603niello
nolo46229313_no_lo
oleo46630483__oleo
olio46829673__olio
olla44821173__olla
ovolo8339173ovo_lo
paella8410913paella
pall65039343_pall_
pallor8313673_pallor
palls74332563_palls
pally105727123_pally
papally1437973papally
papilla11127913papilla
papillon1244723papillon
phyllo1435873phyllo
pill65339463_pill_
pillow113110573_pillow
pills74130973_pills
poco86826153_po_co
poilu72316003_poilu
pol56449383_po_l_
polar75623453_polar
pole65951303_po_le
poled84934843_poled
poler74431793_poler
poles75351003_poles
polios84019723_polios
polis74731163_polis
polka11310413_polka
polled94022003_polled
pollee83623273_pollee
pollen83416453_pollen
poller83921853_poller
pollex153711163_pollex
pollock1546843_pollock
polos76129913_polos
pols66044563_po_ls
poly96235153_po_ly
polyol1138713_polyol
polyp125611533_polyp
polys105718763_polys
pomelo10238663_pomelo
pomo85828453_po_mo
poo57757113_po__o
pool65835953_pool_
pools74427703_pools
porno75120653_porno
potto75320943_potto
poult76928873_poult
pull64731663_pull_
pulls74425053_pulls
quoll14379493quoll_
quolls15327303quolls
repoll8410793repoll_
repolls939053repolls
roll46331653_roll_
rolls55326233_rolls
scollop11275433scollop
soldo67116563_soldo
solo45538943_so_lo
spall74919303spall_
spalls84217343spalls
spell75020303spell_
spells84617683spells
spill74821163spill_
spills84717463spills
spoil75818653spoil_
spoils84614533spoils
spoilt85016593spoilt
spool75219043spool_
spools85115913spools
tapalo839793tap_alo
toll45535263_toll_
tolls54728433_tolls
troll54416533troll_
trollop944793trollop
trolls64613943trolls
trolly94012363trolly
wholly15366573wholly
woolly12408513woolly

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.373479064.3
2DLD Change Limit1127162015.48320557.4
3Display Results2012010.0633190.5
 (SQL Overall)1786912015.91930189.4
 
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.