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

164 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
shul7582315(None) 
saul45836521saul
schul102510411schul
shaul85418101shaul
shuln84713111shuln
shuls85319711shuls
shun75122771shun
shut76137581shut
soul46435711soul
ahull84010312ahull
bhut95425712bhut
buhl95518222buhl
caul65630002caul
chub115516412chub
chug105914112chug
chum116318002chum
churl105913882churl
dhal86719282dhal
foul77027582foul
ghoul959052ghoul
gul45832792_gul
haul75530452haul
hub86437482_hub
hue66642302_hue
hug76037362_hug
huh96432012_huh
hula74923752_hula
hulk115321612_hulk
hull75428782_hull
hum85542932_hum
hun65844712_hun
hup86437812_hup
hurl76029932_hurl
hut66457292_hut
maul64830712maul
phut96925972phut
pul56138062_pul
rhus75114052rhus
sail45447162sail
sal36462882s_al
sall44544682sall
sau36356572sau_
sauls55128122sauls
sault55834962sault
schuln11256232schuln
schuls11299852schuls
scud76221282scud
sculk115112462sculk
scull75315762scull
sculp95314842sculp
scum85924522scum
scup84822382scup
scut65835542scut
seal45654372seal
seel45042982seel
sel38253322s_el
sell45840612sell
sh56828522sh__
sha69837782sh_a
shad86230912shad
shag86430562shag
shah105627782shah
shale85332832shale
shall85024052shall
shalt85534482shalt
shaly114322862shaly
sham96436352sham
shat76456592shat
shauls94913112shauls
shaw108132552shaw
shawl116217572shawl
shay107133342shay
she66837692sh_e
shea76031572shea
sheal84927702sheal
shed86536152shed
shelf115221112shelf
shell84424122shell
sheol84318362sheol
shes75734352shes
shew108030762shew
shh97121072sh_h
shiel811023772shiel
shill85325332shill
shily115222012shily
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shlub105411742shlub
shmo95318092shmo
shoal83920262shoal
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shool84523142shool
shop95629832shop
shorl84720242shorl
shot76150242shot
should1038022should
shout85433162shout
show106229182show
shri76021692shri
shrub104814892shrub
shrug94512512shrug
shuck144314532shuck
shuns85018142shuns
shunt85226502shunt
shush113812542shush
shute84520342shute
shuts85622472shuts
shwa106014962shwa
shy96728192sh_y
shyly144811572shyly
sial45938832sial
sill45545152sill
skua86113152skua
skulk8479622skulk
skull94812032skull
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
smug75815262smug
smut66629782smut
snub65320762snub
snug55218692snug
soil46138822soil
sol37256622s_ol
sou37853692sou_
souk86127172souk
souls55127362souls
soup66232912soup
sour45935892sour
sous46947212sous
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
stub66221842stub
stud56220092stud
stull54916272stull
stum65526012stum
stun45623452stun
sub55445552s_ub
sue35651462s_ue
suk75632972s_uk
sulk85326652s_ulk
sulu45128422s_ulu
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
swum96416822swum
thud85613912thud
thug86415482thug
thurl84912682thurl
thus76721472thus
waul76927312waul
whup125714162whup

Search took 3 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.1561145455.1
2DLD Change Limit298721642.15613855.3
3Display Results1641640.0762157.9
 (SQL Overall)1786911642.38874828.7
 
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.