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

266 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
thralls1029904(None) 
thrall93810291thrall_
thrills10398781thrills
enthralls12256132enthralls
halls85633782_h_alls
inthralls12216232inthralls
shrills10389932shrills
talls55133432t__alls
thalli958922th_alli
thallus1035602th_allus
thills95515382th_ills
thralled1245802thralled
thraves13469712thraves
thraws129211102thra_ws
thrill94910592thrill_
trails64622512t_rails
trawls94412392t_rawls
trills64319852t_rills
trolls64613942t_rolls
trulls64110282t_rulls
alls46740923___alls
appalls11337743appalls
ashfalls1443433ashfalls
aurally10310543aurally
balls76236413__balls
befalls12349123befalls
begalls10319163begalls
bharals1236733bharals
borals86721913bora_ls
brails84621293_brails
brawls115214333_brawls
brills84916293_brills
calls75634733__calls
chalks155412143ch_alks
challa114014193ch_alla
challas124414123ch_allas
challis124613463ch_allis
chally144314293ch_ally
chills114717703ch_ills
chorales133712883chorales
chorally1638103chorally
chorals124614113chora_ls
corals85325143cora_ls
craals84113303_craals
crawls114712083_crawls
derails84216393derails
dhals95415443dh_a_ls
drails74716953_drails
drawls105511393_drawls
drills74414203_drills
drolls75312393_drolls
enrolls7108093enrolls
enthrall11266833enthrall_
enthrals11278903enthra_ls
falls85727653__falls
ferals94216643fera_ls
frails93716473_frails
frills94414223_frills
galls64729323__galls
ghylls1335143gh_ylls
gorals76917653gora_ls
graals74112913_graals
grails77518783_grails
grills74314803_grills
gyrally1435583gyrally
hails85231643_h_ails
halals95018313_h_alals
hales85449843_h_ales
hall75741163_h_all_
hallo85127553_h_allo
hallos95425103_h_allos
halms105225213_h_alms
halos85230253_h_alos
halts85230103_h_alts
harls85634503_h_arls
hauls86123733_h_auls
heals85733463_hea_ls
hells85032043_h_ells
heralds1137713heralds
hills85431353_h_ills
hulls84923563_h_ulls
ihrams1137173ihra_ms
infalls1038943infalls
inthrall11247063inthrall_
inthrals11258503inthra_ls
inwalls1037283inwalls
jurally1736963jurally
kraals10378433_kraals
krills104211283_krills
lalls55324133__lalls
malls76233433__malls
morales93619403morales
morally12411493morally
morals85324643mora_ls
mothballs1643923mothballs
murals84016763mura_ls
ooralis7312553ooralis
orally93113593_orally
orals55826483_ora_ls
overalls11410393overalls
palls74332563__palls
phalli1148263ph_alli
phallus1236063ph_allus
phials1158873phia_ls
phrases12711463phrases
prills84015613_prills
rails55937403__rails
rales54947493__rales
rally84725903__rally
recalls92613623recalls
refalls103312243refalls
rerolls739943rerolls
rills55032713__rills
rolls55326233__rolls
rurally1038303rurally
scalls84218203_scalls
scrawls12177283scrawls
scrolls938063scrolls
serails73318363serails
shales94731253sh_ales
shall85024053sh_all_
shauls94913113sh_auls
shawls125411973sh_awls
sheals94420643shea_ls
shells94319523sh_ells
shills94519613sh_ills
shoals94215793shoa_ls
shrill94712303shrill_
shrilly13318563shrilly
smalls84514123_smalls
spalls84217343_spalls
sprawls12176373sprawls
squalls1647313squalls
stalls64019933_stalls
strolls739183strolls
taels56822073t__aels
tails55634193t__ails
talas55935893t__alas
talcs74817183t__alcs
tales55451373t__ales
talks94322693t__alks
tall47240213t__all_
tallis63319963t__allis
tally84526863t__ally
talus55423263t__alus
tamales93216153tamales
tamals84116633tama_ls
tapalos938813tapalos
taramas9612703taramas
tarnally1138273tarnally
tarsals72512603tarsals
teals56234133t_ea_ls
tells55828943t__ells
tenails73713923tenails
tepals85415043tepa_ls
terais64023513tera_is
tercels94110363tercels
thacks154311923th_acks
thaler94613103th_aler
thalers106212263th_alers
thallic1246553th_allic
thallous1136523th_allous
thanes94918983th_anes
thanks134313133th_anks
tharms115712243th_arms
thaws116515463th_a_ws
theelols1144413theelols
thermally1744833thermally
thermals13518533thermals
thermels13607763thermels
thiazols2042473thiazols
thill85918733th_ill_
thiols95112763th_iols
thirams1236823thira_ms
thirls95012063th_irls
tholes94919783th_oles
tholos94213003th_olos
thoraces13118943thoraces
thoraxes1896363thoraxes
thraldom1442813thraldom
thraldoms1542893thraldoms
thralldom1551283thralldom
thralldoms1651343thralldoms
thralling13256833thralling
thrash12258363thra_sh
thrashes1487653thrashes
thrave126010273thra_ve
thraw1110515923thra__w
thrawed1435583thrawed
thrawn12769423thra_wn
thrawnly1741793thrawnly
threads11419953threads
threaps12488643threaps
threats104311673threats
threeps12687043threeps
threes97117323thr_ees
thrifts1335523thrifts
thrilled1235493thrilled
thriller1165553thriller
thrillers1244473thrillers
thrips11299013thr_ips
thrives134611713thrives
throats104612193throats
throbs118311373thr_obs
throes97518673thr_oes
thrones105715843thrones
throngs11508163throngs
throws129715233thr_ows
thrums11429123thr_ums
thrusts10226523thrusts
thurls9418713th_urls
thwacks1953613thwacks
thwarts1345023thwarts
thymols1533843thymols
ticals83214713tica_ls
tidally1137933tidally
tills54631713t__ills
tirades8311723tirades
tirls54519803tir__ls
tolls54728433t__olls
tonally10311373tonally
torahs95115643tora_hs
toras55540373tora__s
torulas759853torulas
totally1039893totally
totals63115163tota_ls
traces85329933t_races
tracks124818843t_racks
tracts85019073t_racts
trades75724503t_rades
tragus749233t_ragus
traiks104013713t_raiks
trail55126773t_rail_
trains64725343t_rains
traits65121983t_raits
tramells10327833t_ramells
tramels93812493t_ramels
tramps105114453t_ramps
trams75327673t_ra_ms
tranks104017763t_ranks
tranqs155210313t_ranqs
trans54933043t_ra_ns
trapes85024463t_rapes
traps75727483t_ra_ps
trass56226473t_ra_ss
travels104711293t_ravels
traves94222743t_raves
trawl84915873t_rawl_
trays85623433t_ra_ys
trellis739873t_rellis
trials64319883t_rials
trill55122933t_rill_
triols66117803t_riols
troll54416533t_roll_
trolly94012363t_rolly
trull54012673t_rull_
turacos938643turacos
turnhalls1242913turnhalls
turtles72914343turtles
twills9489793t_wills
tyrants1037453tyrants
unrolls797793unrolls
virally1339653virally
walls85529383__walls
whales124716943wh_ales
wheals124512523whea_ls

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.390458182.1
2DLD Change Limit1340272667.48317910.9
3Display Results2662660.0962770.8
 (SQL Overall)1786912667.96922423.3
 
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.