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

160 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
stob6672461(None) 
slob66029421slob
snob65825591snob
sob57857941s_ob
stab67329931stab
stoa45425911stoa
stobs75718231stobs
stop66532031stop
stot46347321stot
stow77325741stow
stub66221841stub
swob95218631swob
atom67824522atom
atop66124752atop
blob86027092blob
bob76755672_bob
boob85932582boob
cob710258752_cob
estop74312102estop
fob86748332_fob
glob76623392glob
gob68950892_gob
hob87550922_hob
job128041772_job
knob107417012knob
kob99442382_kob
lob57154462_lob
mob78651922_mob
nob58954422_nob
rob56754302_rob
sab56563202s_ab
scab85926712scab
scop85925522scop
scot66242602scot
scow96021422scow
seton55223542seton
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
sib56850312s_ib
sibb85921422sibb
slab67133762slab
slobs74419872slobs
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049822slot
slow77729492slow
slub65428032slub
smog76317412smog
snib66522982snib
snobs74716152snobs
snog55623632snog
snot44745442snot
snow76324792snow
snub65320762snub
so28855442s_o_
soba64927922s_oba
sobs64941752s_obs
sod46053702s_od
sol37256622s_ol
som59153802s_om
son37761952s_on
sook84933392sook
soon46240502soon
soot45761052soot
sop57557862s_op
sorb68333042sorb
sos37761602s_os
sot310384292s_ot
soth75932512soth
sotol54917642sotol
sots45552442sots
sou37853692s_ou
sow66554762s_ow
sox106444192s_ox
soy67851452s_oy
spot65540682spot
stabs76221382stabs
stag57332002stag
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
stem610628242stem
step67126292step
stet45947322stet
stew77525462stew
stey76224412stey
stir45723242stir
stoae55024262stoae
stoai55417862stoai
stoas55126022stoas
stoat57135952stoat
stock114417562stock
stogy95414082stogy
stoic7317242stoic
stoke94922512stoke
stole54928812stole
stoma75918272stoma
stomp95616662stomp
stone55431182stone
stony85818642stony
stood65517712stood
stook95218212stook
stool55619892stool
stoop75821542stoop
stope74727242stope
stops74827282stops
stopt76528352stopt
store56333812store
stork96819692stork
storm76520372storm
story86723032story
stoss54316342stoss
stots54828542stots
stott56929782stott
stoup75517072stoup
stour54916742stour
stout57434052stout
stove85220252stove
stowp105614232stowp
stows86622702stows
strobe84513812strobe
strop77422242strop
strow88920572strow
stroy87720392stroy
stubs75016072stubs
stud56220092stud
stum65526012stum
stun45623452stun
sty66227312st_y
stye76218972stye
sub55445552s_ub
swab96825312swab
swobs104910892swobs
swop95120502swop
swot75134652swot
sybo9714742sybo
tab57460322_tab
to218858982_to_
toby96322292_toby
tod49457072_tod
toe310166852_toe
tog410255042_tog
tom514358052_tom
tomb89029652_tomb
ton310265102_ton
too38965422_too
top510560682_top
tor39261682_tor
tot38884772_tot
tow610557362_tow
toy69655192_toy
tub55640032_tub
yob87945272_yob

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 Filter178691298720.1431249587.4
2DLD Change Limit298721602.40312431.1
3Display Results1601600.1431118.9
 (SQL Overall)1786911602.68966452.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.