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

111 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
stoup7551707(None) 
soup66232911s_oup
stomp95616661stomp
stoop75821541stoop
stop66532031sto_p
stoups85313271stoups
stour54916741stour
stout57434051stout
stowp105614231stowp
atop66124752ato_p
coup86729792_coup
croup95616782croup
estop74312102esto_p
group85413922group
loup66028432_loup
roup66627692_roup
scaup95515992scaup
scoop95617162scoop
scop85925522sco_p
scour75315532scour
scout75031452scout
scup84822382s_cup
setous64917372setous
setout64719462setout
setup73915822setup
shop95629842sho_p
shout85433172shout
sirup74014912sirup
situp74414062situp
sloop76118912sloop
slop66533872slo_p
snoop75317172snoop
snout54530632snout
soap65831132s_oap
sop57557862s_o_p
sou37853692s_ou_
souk86127172s_ouk
soul46435712s_oul
soups75322942s_oups
soupy106115402s_oupy
sour45935892s_our
sous46947212s_ous
spout75029632spout
stamp95217362stamp
steep76020702steep
step67126292st_ep
stirp76815502stirp
stoa45425912sto_a
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stogy95414082stogy
stoic7317252stoic
stoke94922512stoke
stole54928812stole
stoma75918272stoma
stomps105612832stomps
stone55431182stone
stony85818642stony
stood65517712stood
stook95218212stook
stool55619892stool
stoops85917892stoops
stope74727242stope
stops74827282stops
stopt76528352stopt
store56333812store
stork96819692stork
storm76520402storm
story86723032story
stoss54316342stoss
stot46347332sto_t
stots54828552stots
stott56929792stott
stound7399902stound
stoure64814942stoure
stours65015632stours
stoury9529942stoury
stouts65019002stouts
stove85220252stove
stow77325742sto_w
stowps115710582stowps
stows86622702stows
strap77925262strap
strep77120852strep
strip77524342strip
strop77422242strop
stroud7310382stroud
strum75619452strum
strut56030732strut
stub66221842st_ub
stud56220092st_ud
stum65526022st_um
stump94616462stump
stun45623452st_un
stupa74112312st_upa
stupe75217752st_upe
sunup7313052sunup
sup57041942s__up
swoop105213432swoop
swop95120502swo_p
swoun84811492swoun
syrup103010962syrup
top510560682_to_p
tour45530382_tour
tout46753822_tout
tup56037542_t_up

Search took 2 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 Filter178691538000.300595636.7
2DLD Change Limit538001111.59333772.8
3Display Results1111110.0303700.0
 (SQL Overall)1786911111.92392923.0
 
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.