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

133 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
sorner6472039(None) 
corner84625621corner
scorner9259761scorner
sooner64220461sooner
sorer56236591sor_er
sorned74820041sorned
sorners73416871sorners
sorter64425091sorter
adorner8246982adorner
boner75133082bo_ner
border94419972border
borer75131272bor_er
borne77926792borne_
burner83819202burner
coiner84323782coiner
conner84423962conner
corder94322882corder
corer75538872cor_er
corker124720852corker
cornea84018932cornea
corned95224522corned
cornel84020052cornel
corners94723312corners
cornet84436732cornet
cornier93017092cornier
coroner94218202coroner
darner74017302darner
dormer94415902dormer
dorper94314572dorper
dorser74819182dorser
downer104414922downer
droner74717672droner
earner63617222earner
forcer114917342forcer
forger104820772forger
forker134717902forker
former114221402former
garner73917002garner
goner66025162go_ner
gorger86116982gorger
gorier73719372gorier
honer85332092ho_ner
horned105718702horned
hornet94926432hornet
hornier103012462hornier
ironer64216452ironer
joiner134114132joiner
kroner104612572kroner
loaner64416502loaner
loner55431042lo_ner
loriner7511892loriner
moaner84415112moaner
mooner85317832mooner
mourner938092mourner
order65019362_order
ormer75218372_ormer
ornery938462_ornery
owner84613312_owner
porker124917542porker
pornier93413132pornier
porter84224412porter
saner54334322s_aner
scorer84818262scor_er
scorned10229952scorned
scorners10228492scorners
seiner64622482seiner
serener73415762serener
serer55935512ser_er
serger73819742serger
server94917712server
shiner93820872shiner
shorter103515502shorter
signer74015632signer
sinner64320602sinner
snorer64316762snor_er
snorter74412662snorter
soaker105717532soaker
soaper84517872soaper
soarer64522242soarer
sobber104016592sobber
sober74822412so_ber
soccer1038542soccer
soever94412092soever
softer94015312softer
solder73921342solder
solver94016702solver
somber103714002somber
sonar56523422so_nar
sonder73623522sonder
sone46649982so_ne_
sones55444142so_nes
sonnet65923502sonnet
sooners73916642sooners
sorbed94916522sorbed
sorbet83924082sorbet
sorcery1237032sorcery
sordor7310222sordor
sore47059532sor_e_
sored66141782sor_ed
sorel56231442sor_el
sores55454282sor_es
sorn46641062sorn__
sorns55028422sorn_s
sorrel6413552sorrel
sorrier72313732sorrier
sorted74523712sorted
sorters74221132sorters
sounder83315382sounder
sourer63620212sourer
souter64225922souter
sower85229312so_wer
sporter93616552sporter
sprier84119062sprier
spryer11418532spryer
spurner9269652spurner
sterner7411912sterner
stoner65823202stoner
storer64721672stor_er
suborner1047382suborner
surer54833102sur_er
surfer93515882surfer
surger74320092surger
swooner10358672swooner
toner55336242to_ner
tonner64819202tonner
turner63914612turner
warner93717222warner
wonner95114442wonner
worker134715112worker
wormer114514912wormer
worser95117522worser
yarner93313062yarner
zoner144520342zo_ner

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 Filter178691825510.653273646.2
2DLD Change Limit825511336.81312116.7
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.51223787.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.