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

177 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
sorting8322181(None) 
porting103021781porting
shorting122514801shorting
snorting92613371snorting
sooting82820961sooting
sorbing102815261sorbing
soring74731881sor_ing
sorning83116811sorning
sporting112415461sporting
aborting11710252aborting
airting83616302airting
assorting1037302assorting
boating103721302boating
bolting104416762bolting
booting103821362booting
borating113414502borating
boring94724872bor_ing
borking144716172borking
carting104228282carting
coating103525312coating
cording113620822cording
coring94433962cor_ing
corking143018822corking
corning103720122corning
cortin82423152cortin_
cortina91915972cortina
cortins92421332cortins
costing104323022costing
coting94629252co_ting
courting112514572courting
darting94020662darting
doating93816862doating
doting84821912do_ting
dotting93314482dotting
escorting1237712escorting
farting114120752farting
footing115017592footing
forcing134013752forcing
fording123717042fording
forging124114722forging
forking154014842forking
forming133615732forming
girting93113332girting
gorging102611362gorging
goring84119572gor_ing
gorming112810832gorming
hooting113919882hooting
hording123517052hording
horning113015002horning
horsing113215582horsing
hosting114318382hosting
hotting113116522hotting
hurting113914032hurting
jolting153410912jolting
jotting152912772jotting
karting123716062karting
lofting113311312lofting
looting83019642looting
lording93115232lording
lotting82917752lotting
louting83719382louting
marting103325012marting
moating104218152moating
molting103517172molting
mooting103019362mooting
morning103215042morning
northing12199062northing
noting74120152no_ting
opting94514402_opting
orating83520322_orating
orbing93312362_orbing
outing74128152_outing
parting103527382parting
poring94227272por_ing
porking143515812porking
posting105622242posting
potting103720892potting
pouting103519942pouting
resorting10614612resorting
rooting83522432rooting
rotting82919682rotting
routing83821092routing
salting84120792salting
sating74735452s_ating
scarting113415262scarting
scooting113012642scooting
scoring103117212scor_ing
scorning1169132scorning
scouting112612752scouting
scrying1338662scrying
seating84130682seating
serging93416672serging
sering74731812ser_ing
serving113014982serving
setting83621392setting
shirting123213612shirting
shooting122812862shooting
shoring112820072shor_ing
shotting123012382shotting
shouting122711792shouting
shuting113212052shuting
sifting113014592sifting
silting83320482silting
siring75128312sir_ing
siting74126622s_iting
sitting83519632sitting
skating123613852skating
skirting13289392skirting
skiting123812502skiting
slating83724652slating
slotting92612612slotting
smarting113212452smarting
smiting103014442smiting
snooting92813202snooting
snoring83917202snor_ing
snouting92511922snouting
soaking123116612soaking
soaping103616222soaping
soaring83521892soaring
sobbing127612882sobbing
socking143518602socking
sodding103712732sodding
soiling83422322soiling
solating9315592solating
soling74226822so_ling
soloing82813802soloing
solving112910852solving
soothing12269972soothing
sopiting11310762sopiting
sopping123917202sopping
sordine82515232sordine
sordini8228962sordini
sordino8219442sordino
sorings83817252sor_ings
sortie63621992sorti_e
sortied83314102sortied
sortieing1046162sortieing
sorties74126402sorties
souping104215532souping
sourcing1158352sourcing
souring83219062souring
sousing83517822sousing
southing122811822southing
sowing104222912so_wing
spirting112913632spirting
spiting103917622spiting
sporing104319412spor_ing
spotting112812092spotting
spouting113511952spouting
spring94526012spr_ing
spurting113111632spurting
starting93116172starting
stating83725162stating
sting65330242s__ting
storing83921122stor_ing
storming11209422storming
storying12249672storying
stotting92811162stotting
string75327562str_ing
suiting83419002suiting
surfing112914482surfing
surging93115432surging
swotting12268482swotting
tarting84222652tarting
toiting83217092toiting
tooting83019422tooting
toting74123792to_ting
totting82816842totting
touting84118452touting
voting103916032vo_ting
wonting113214102wonting
wording123014562wording
working153813252working
worming132811242worming
worsting1267682worsting
worthing15178052worthing
wotting112913842wotting

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.373479064.3
2DLD Change Limit1076711773.39031761.4
3Display Results1771770.0632809.5
 (SQL Overall)1786911773.82646704.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.