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 “dialing” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
dialing9431817(None) 
dealing94323231dealing
dialings10329821dialings
dialling10310781dialling
dirling93316071dirling
vialing113614161vialing
ailing74331012ai_ling
bailing103723522bailing
baling94829692_baling
biasing103512452biasing
billing103823852billing
birling104317052birling
coaling103722832coaling
daring84928682d_aring
darling93418372darling
dating85326482d_ating
dawing114819822d_awing
dazing175516512d_azing
dealings103510702dealings
deaning94020472deaning
deaving123814752deaving
dialist8517762dialist
diallings1134992diallings
dialog837972dial_og
dialoging1246312dialoging
dialysing1444482dialysing
dialyzing2344042dialyzing
diamin9312522diamin_
diamine10311982diamine
diamins10312212diamins
diazin1639162diazin_
diazine1738932diazine
diazins1739182diazins
dibbing133110892dibbing
dibbling14247332dibbling
dicing105718762di_cing
dicking153617612dicking
dicliny1337672dicliny
diddling12228742diddling
dieing84018652di_eing
dieting93616832dieting
digging113513702digging
diking124320242di_king
dilating102714912dilating
dimming13339592dimming
dimpling14199022dimpling
dindling112411162dindling
dinging103618612dinging
dining84525132di_ning
dinking133618282dinking
dinning93416552dinning
dinting93520552dinting
dipping134014832dipping
dirking133812602dirking
disabling1337752disabling
discing113914592discing
dishing124017102dishing
disking134615492disking
dissing94517682dissing
diving113717952di_ving
doating93816862doating
doling84923132d_oling
dolling93817372dolling
draping114213352draping
drawing123812052drawing
drawling13318672drawling
draying123813842draying
drilling103311982drilling
dueling93614542dueling
dulling93418272dulling
failing113521332failing
filing103823762fi_ling
filling113520802filling
foaling113515842foaling
gilling93520382gilling
goaling93515332goaling
hailing113820692hailing
haling104229782_haling
healing113922962healing
hilling113821772hilling
idling8912882_idling
isling71213882_isling
jailing153415842jailing
killing123118722killing
kitling123313572kitling
mailing102923352mailing
miauling1137342miauling
milling103223682milling
nailing83419962nailing
nilling83619562nilling
oiling74925312oi_ling
paling93530132_paling
pealing104123202pealing
piling95025592pi_ling
pilling103722562pilling
railing83325642railing
redialing11311842redialing
rifling112815012rifling
riling74227972ri_ling
rilling84023622rilling
rivaling1239912rivaling
sailing83927372sailing
scaling103519372scaling
sealing83528562sealing
sibling10814422sibling
sidling9915422sidling
staling83925422staling
tailing82923102tailing
tiling73426552ti_ling
tilling83522782tilling
tirling83315732tirling
titling83715792titling
vailing113817952vailing
vealing114217422vealing
vialling1237222vialling
wailing113620902wailing
waling104525302_waling
whaling143910772whaling
wiling103024292wi_ling
willing113821612willing
witling113215812witling
yealing112716382yealing

Search took 4 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 Filter1786911076710.406440125.6
2DLD Change Limit1076711223.40631612.2
3Display Results1221220.0631936.5
 (SQL Overall)1786911223.87546113.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.