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

149 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
shoat8563395(None) 
shat76456601sh_at
shoal83920271shoal
shoats94117081shoats
shoot84235911shoot
short85040531short
shot76150261sho_t
shott85332191shott
shout85433171shout
stoat57135951stoat
bhoot104322102bhoot
bloat75229922bloat
boat66360312_boat
chat95546132ch_at
cheat105732452cheat
chott103923932chott
coat67558352_coat
doat56947672_doat
float85928572float
ghat86435282gh_at
ghost96318762ghost
gloat65427682gloat
goat56250832_goat
groat65531972groat
hat67289962_h_at
heat77061422_heat
hoar76729162_hoar
hoax147718292_hoax
holt77852582_holt
hoot75752102_hoot
host77852832_host
hot67776062_ho_t
khat116730722kh_at
moat66352032_moat
oat39888262__oat
phat95837862ph_at
phot95534362pho_t
sat36288482s__at
scat65848372s_cat
scoot75729152scoot
scot66242612sco_t
scout75031452scout
seat47575562s_eat
sha69837782sh_a_
shad86230912sh_ad
shaft115725272shaft
shag86430562sh_ag
shah105627782sh_ah
shalt85534492shalt
sham96436362sh_am
shaw108132552sh_aw
shay107133342sh_ay
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheath12412892sheath
sheet84836962sheet
shent85933502shent
shift114225142shift
shirt84533902shirt
shist84829612shist
shit76745942sh_it
shoals94215792shoals
shoaly124010772shoaly
shock144917032shock
shod86225062sho_d
shoe75933442sho_e
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shofar1236312shofar
shog86025142sho_g
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
shone83725982shone
shoo75929892sho_o
shook124920162shook
shool84523152shool
shoon84022012shoon
shoos84226362shoos
shoots94619362shoots
shop95629842sho_p
shops104222902shops
shoran94016042shoran
shore85432652shore
shorl84720252shorl
shorn85722182shorn
shorts95321742shorts
shorty124313202shorty
shote85526102shote
shots84730852shots
shotts93614702shotts
shouts94017722shouts
shove114421042shove
show106229192sho_w
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shunt85226512shunt
shut76137592sh_ut
shwa106014962shwa_
shwas116415102shwas
skat87037902s_kat
skoal93811462skoal
skort94925642skort
slat46959022s_lat
slot46049832slo_t
smolt74824162smolt
snoot55030142snoot
snort54833752snort
snot44745452sno_t
snout54530632snout
soak87227662s_oak
soap65831132s_oap
soar46838672s_oar
soft76942822s_oft
soot45761062s_oot
sort46264812s_ort
sot310384302s_o_t
spat66548522s_pat
splat76129342splat
sport75935982sport
spot65540692spo_t
spout75029632spout
sprat76635972sprat
squat143720142squat
stat47352692s_tat
stoa45425912stoa_
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoats65117482stoats
stopt76528352stopt
stot46347332sto_t
stott56929792stott
stout57434052stout
swat77244442s_wat
sweat85628402sweat
swot75134662swo_t
that75639322th_at
throat94819752throat
what105434072wh_at
wheat114924572wheat
whoa106615202whoa_
whort114623692whort

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 Filter178691538000.330541487.9
2DLD Change Limit538001491.73331044.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911492.10984727.8
 
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.