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 “shaduf” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

204 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
shaduf133706(None) 
shadufs1433671shadufs
shad86230912shad__
shade95125582shad_e
shaded114518872shaded
shader104218762shader
shades105924532shades
shadoof1446132shadoof
shadow1337252shadow
shads95124482shad_s
shady125416512shad_y
shamus114112812shamus
sharif122917122sharif
shaul85418102sha_ul
bahadur1342603bahadur
chabuk1734673chabuk
chad105525503chad__
chadar1239353chadar
chador1238673chador
chadri1238143chadri
chads116122233chad_s
chaff165016283cha_ff
ghaut95919433gha_ut
gradus84411223gradus
haaf106227733_ha_af
habu97325483_habu_
habus106317143_habus
had77658763_had__
hadal95518123_hadal
hade85440193_had_e
haded105227623_haded
hades96035113_hades
hadj155818673_had_j
hadji16839893_hadji
hadst93220223_hadst
haku116923893_haku_
hakus125114113_hakus
half106238453_ha_lf
haul75530453_ha_ul
haut75949733_ha_ut
khadi1367603khad_i
khadis1446913khadis
khaf145319603kha__f
khalif1657833khalif
sad47459203s_ad__
sade55544473s_ad_e
sades65239893s_ades
sadhe94815133s_adhe
sadhu9459963s_adhu
sadhus10298463s_adhus
sadi55834643s_ad_i
sadis64930853s_adis
sadly94519123s_adly
sagum8512873s_agum
sau36356573s_a_u_
saul45836523s_a_ul
scad75725773scad__
scads85419963scad_s
scarf105427143sca_rf
scaup95515993sca_up
scaur75814903sca_ur
seadog838743seadog
sedum84115573s_edum
sendup9106343sendup
sha69837783sha___
shabby1635803shabby
shack145321753sha_ck
shacko153810113shacko
shacks154817563shacks
shadbush1741973shadbush
shaders115915553shaders
shadfly1733783shadfly
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shadoofs1554233shadoofs
shadows1437193shadows
shadowy1744723shadowy
shaft115725263sha_ft
shafts125411443shafts
shag86430563sha__g
shaggy14478043shaggy
shags95123863sha_gs
shah105627783sha__h
shahdom1643973shahdom
shahs115919513sha_hs
shaird10288703shaird
shairn9269063shairn
shake124726403sha_ke
shaken134113613shaken
shaker134319463shaker
shakes135024593shakes
shakeup1632763shakeup
shako125516093sha_ko
shakos134912193shakos
shaky154616843sha_ky
shale85332833sha_le
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053sha_ll
shalom11810923shalom
shalt85534493sha_lt
shaly114322863sha_ly
sham96436363sha__m
shaman113314283shaman
shamas113717943shamas
shame105726703sha_me
shamed125120213shamed
shames114726223shames
shammy16388503shammy
shamos114216983shamos
shamoy14379913shamoy
shams105829413sha_ms
shandy134710033shandy
shank125422193sha_nk
shanks135315583shanks
shanny124110093shanny
shanti94014093shanti
shanty124715123shanty
shape105125113sha_pe
shaped125020103shaped
shapen114414653shapen
shaper114119933shaper
shapes115124943shapes
shapeup1443293shapeup
shard96125963sha_rd
shards104319173shards
share86437083sha_re
shared105829063shared
sharer95025483sharer
shares95236413shares
sharia93116733sharia
sharifs13279903sharifs
shark126225023sha_rk
sharks135019723sharks
sharn84823703sha_rn
sharns95516983sharns
sharny124711833sharny
sharp104922533sha_rp
sharps115516083sharps
sharpy145211033sharpy
shat76456603sha__t
shaugh13287433shaugh
shauls94913113shauls
shave114425893sha_ve
shaved135118383shaved
shaven124213303shaven
shaver123718913shaver
shaves125224933shaves
shavie124312423shavie
shaw108132553sha__w
shawed134817233shawed
shawl116217573sha_wl
shawls125411973shawls
shawm135316153sha_wm
shawms14579563shawms
shawn116417613sha_wn
shaws116226263sha_ws
shay107133343sha__y
shays116021433sha_ys
shazam2046623shazam
sheaf115424123sh_eaf
shed86536153shed__
sheds96122703shed_s
shelf115221113sh_elf
sherif122915243sherif
shlub105411743sh_lub
shod86225063shod__
shoddy1434543shoddy
shogun1045713shogun
shout85433173sh_out
shoyu1138913shoyu_
shoyus1266003shoyus
shroff1538503shroff
shroud1038773shroud
shrub104814893sh_rub
shrug94512513sh_rug
shul75823153sh__ul
shun75122773sh__un
shut76137593sh__ut
siddur834573siddur
snafu8412143snafu_
snafus936743snafus
snarf86525423sna_rf
spade84423323spad_e
spaded103816753spaded
spader94317133spader
spades94222583spades
spadix1636113spadix
spado83713703spad_o
sradha1085333sradha
stade64825303stad_e
stades74626243stades
stadia7312143stadia
stadium1038073stadium
staff113817713sta_ff
standup1034353standup
statue66015323statue
status65515213status
subdue9128493subdue
swarf115324653swa_rf
wharf14315823wha_rf
whaup13458883wha_up

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162045.67319868.9
3Display Results2042040.0603400.0
 (SQL Overall)1786912046.10929250.5
 
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.