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

164 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
thralling1325683(None) 
thrilling13276691thrilling
enthralling1543842enthralling
inthralling1544112inthralling
shrilling13307692shrilling
thrashing1635682thrashing
thrawing1535962thra_wing
totalling1036522totalling
trailing92916092t_railing
trawling122710782t_rawling
trilling92815962t_rilling
trolling93212492t_rolling
appalling1444923appalling
balling104424763__balling
befalling15226503befalling
begalling13216493begalling
brailing113514793_brailing
brailling1247773_brailling
brawling143210043_brawling
caballing1436883caballing
calling103826773__calling
canalling1239553canalling
carolling1259413carolling
chalking183310063ch_alking
chilling143512183ch_illing
coralline1147943coralline
corralling1345433corralling
craaling112711353_craaling
cradling122411453_cradling
crawling143110513_crawling
derailing112011313derailing
dialling10310783_dialling
drawling13318673_drawling
drilling103311983_drilling
drolling103510763_drolling
enrolling1087733enrolling
equalling1945243equalling
falling113621583__falling
frilling123011493_frilling
galling93921963__galling
grayling1338003_grayling
grilling103811533_grilling
hailing113820693_h_ailing
haling104229783_h_a_ling
halloing121510073_h_alloing
haloing113814133_h_aloing
halting114419073_h_alting
halving143511543_h_alving
hauling113714433_h_auling
healing113922963_hea_ling
helling114623223_h_elling
heralding1435773heralding
hilling113821773_h_illing
hulling113619013_h_ulling
infalling1356243infalling
inwalling1385633inwalling
kraaling13186663_kraaling
lalling83519623__lalling
lateralling1244633lateralling
malling103623663__malling
medalling1346923medalling
metalling1249593metalling
mothballing1952313mothballing
palling104024483__palling
pedalling1346663pedalling
perilling12410003perilling
phrasing1438013phra_sing
prilling113413413_prilling
railing83325643__railing
ralline73518413__ralline
rallying12289013__rallying
recalling122211903recalling
refalling132010423refalling
rerolling102210373rerolling
rilling84023623__rilling
rivalling1335963rivalling
rolling83620413__rolling
scrawling15195583scrawling
scrolling12187803scrolling
shauling1249393sh_auling
shawling1558223sh_awling
shealing123415463shea_ling
shearling1336923shearling
shelling123515213sh_elling
shilling123315383sh_illing
shoaling123111753shoa_ling
spalling113213463_spalling
spiralling1343963spiralling
sprawling15175123sprawling
squalling1935173squalling
stalling95116703_stalling
strolling10238793strolling
tabling103216033t__abling
tailing82923103t__ailing
talcing103111633t__alcing
talking123815823t__alking
tallying12318833t__allying
teazling1856573t_eazling
telling83321083t__elling
thacking183110043th_acking
thalli958923th_alli__
thallic1246553th_alli_c
thallium1344433th_allium
thanking16409523th_anking
thawing14378683th_a_wing
thirling12248583th_irling
tholing112812333th__oling
thrall93810293thrall___
thralldom1551283thralldom
thralled1245803thrall_ed
thralls10299043thrall__s
thrashings1742783thrashings
threading14107593threading
threaping15106113threaping
threating131010053threating
threeping15104803threeping
threshing1645663threshing
thrillingly1851713thrillingly
thriving15246353thr_iving
throating1398403throating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throttling1442793throttling
throwing1536723thr_owing
thrumming1742903thrumming
thrusting1335013thrusting
thwacking2253193thwacking
thwarting1632763thwarting
tilling83522783t__illing
tirling83315733tir__ling
tolling83418563t__olling
totaling9610303tota_ling
towelling1366253towelling
trachling1537823t_rachling
tracing103720153t_ra_cing
tracking153715463t_racking
trading93517973t_ra_ding
traiking132511973t_raiking
training93015863t_raining
trameling1249053t_rameling
tramelling1346373t_ramelling
tramline10311383t_ramline
tramming13279343t_ramming
tramping132711273t_ramping
trampling1436973t_rampling
trancing112812023t_rancing
trapline10411863t_rapline
trapping132911393t_rapping
trashing122613223t_rashing
traveling1349053t_raveling
travelling1456533t_ravelling
treadling1137503treadling
trebling1139873t_rebling
trifling122411503t_rifling
tripling112712553t_ripling
trollings10286693t_rollings
trollying1354053t_rollying
turtling9238833tur_tling
twilling12268673t_willing
unrolling1078563unrolling
vialling1237223_vialling
walling113520973__walling
whaling143910773wh_a_ling

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 Filter1786911486410.843211970.3
2DLD Change Limit1486411647.82618993.2
3Display Results1641640.0632603.2
 (SQL Overall)1786911648.73220463.9
 
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.