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

125 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
totalling103652(None) 
totaling9610301tota_ling
metalling1249592metalling
retotalling1244042retotalling
stalling95116702_stalling
thralling13256832thralling
tolling83418562to__lling
totalising1147312totalising
totalizing2079222totalizing
towelling1366252towelling
appalling1444923appalling
balling104424763__balling
befalling15226503befalling
begalling13216493begalling
bobtailing1543513bobtailing
bolling103820883bo__lling
bottling11279143bot_tling
bowelling1566493bowelling
caballing1436883caballing
calling103826773__calling
canalling1239553canalling
catcalling1545123catcalling
coaling103722823co_a_ling
coralline1147943coralline
corralling1345433corralling
detailing112510413detailing
dialling10310783_dialling
dolling93817373do__lling
dowelling1466253dowelling
entailing1039393entailing
equalling1945243equalling
extolling1744623extolling
falling113621583__falling
foaling113515843fo_a_ling
galling93921963__galling
goaling93515333go_a_ling
hostelling1446163hostelling
hovelling1636163hovelling
infalling1356243infalling
installing1146403installing
inwalling1385633inwalling
lalling83519623__lalling
lolling83415783lo__lling
lowballing1642273lowballing
malling103623663__malling
medalling1346923medalling
metaling111613723meta_ling
metalline1158733metalline
modelling1336883modelling
mothballing1952313mothballing
mottling11197753mot_tling
notating92513343nota_ting
palling104024483__palling
pedalling1346663pedalling
polling102920383po__lling
recalling122211903recalling
refalling132010423refalling
retailing103214733retailing
retallying1464703retallying
retelling102112493retelling
retotaling1186883retota_ling
rivalling1335963rivalling
rolling83620413ro__lling
rotating92614553rota_ting
rototilling1252643rototilling
rowelling1366993rowelling
spalling113213463_spalling
squalling1935173squalling
stabling112913653_stabling
staling83925423_sta_ling
stalking133512223_stalking
stapling112813153_stapling
starling93017123_starling
stilling93415323_stilling
subtotalling1551813subtotalling
tabling103216033__tabling
tailing82923103__tailing
talcing103111633__talcing
talking123815823__talking
tallying12318833__tallying
tattling9259473tat_tling
teazling1856573t_eazling
teetotalling1351863teetotalling
telling83321083__telling
thrilling13276693thrilling
tilling83522783__tilling
titling83715793tit__ling
toadying1335043to_adying
toasting93410583to_asting
toddling11187003to_ddling
toenailing1143573toenailing
toggling11206483to_ggling
toiling83219023to__iling
toling73926123to___ling
tooling82918313to__oling
tootling9279523to_otling
toppling13197353to_ppling
tortellini1053543tortellini
totalise8312503tota_lise
totalism10311093tota_lism
totalist8315583tota_list
totality1139373tota_lity
totalize17311523tota_lize
totalled935843totall_ed
totally1039893totall__y
totaquine1851833totaquine
toting74123793tot___ing
tottering10229613tottering
totting82816843tot__ting
tousling938793to_usling
touzling1835503to_uzling
toweling122910373to_weling
towellings1452893towellings
trailing92916093t_railing
trawling122710783t_rawling
treadling1137503treadling
trilling92815963t_rilling
trolling93212493t_rolling
trowelling1484913trowelling
twattling1332693twattling
twilling12268673t_willing
uptalking1643353uptalking
vialling1237223_vialling
walling113520973__walling
yodelling1435193yodelling

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411257.45019951.8
3Display Results1251250.0502500.0
 (SQL Overall)1786911257.90622601.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.