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

138 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
shri7602170(None) 
sari45444041sari
shris84221451shris
sori46039841sori
sri35634001s_ri
abri65522212abri
ahi68040232ah_i
chai95929902chai
chi86228652ch_i
ghi77019882gh_i
gyri85415152gyri
hi57947582_h_i
khi106318302kh_i
lari45839152lari
liri45128252liri
miri66730372miri
nori47133142nori
peri65636972peri
phi86524202ph_i
puri65931442puri
sadi55834642sadi
saki85628482saki
sard55344242sard
sarin55239252sarin
saris54544952saris
sark84938972sark
sati45539332sati
schrik15206702schrik
scrim95419732scrim
scrip96619192scrip
scry96017762scry
sei36048932s_ei
semi65127222semi
ser36752402ser_
sera46141392sera
serai56830162serai
sere46153472sere
serf76340112serf
serif84132132serif
serin55434442serin
sers45746652sers
sh56828522sh__
sha69837782sh_a
shad86230912shad
shag86430562shag
shah105627782shah
sham96436362sham
shard96125962shard
share86437082share
sharia93116732sharia
sharif122917122sharif
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456602shat
shaw108132552shaw
shay107133342shay
she66837692sh_e
shea76031572shea
shed86536152shed
sheik122514662sheik
sherd96321152sherd
sherif122915242sherif
shes75734352shes
shew108030762shew
shh97121072sh_h
shim95827862shim
shin75634312shin
ship95228242ship
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shit76745942shit
shiv105721172shiv
shmo95318102shmo
shod86225062shod
shoe75933442shoe
shog86025142shog
shogi95014012shogi
shoji15419962shoji
shoo75929892shoo
shop95629842shop
shore85432652shore
shorl84720252shorl
shorn85722182shorn
short85040532short
shot76150262shot
show106229192show
shred98125612shred
shrew119720162shrew
shriek134211102shriek
shrift12413542shrift
shrike134513242shrike
shrill94712302shrill
shrimp13478772shrimp
shrine94920052shrine
shrink134511732shrink
shrive125216952shrive
shrub104814892shrub
shrug94512512shrug
shtik123210962shtik
shul75823152shul
shun75122772shun
shut76137592shut
shwa106014962shwa
shy96728192sh_y
si29149572s__i
sir35746672sir_
sire46150412sire
sirs44338332sirs
ski74925692s_ki
soli46637012soli
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sorn46641062sorn
sort46264812sort
sprig85617742sprig
sprit76736402sprit
spry96819122spry
sris45434152s_ris
stir45723252stir
stria55723212stria
strip77524342strip
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
syli74318982syli
thir76420542thir
thrip103012182thrip
thro77726422thro
thru76818942thru
tori47542152tori
whir105519282whir
zori137722922zori

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 Filter178691298720.0802233637.5
2DLD Change Limit298721380.89033564.0
3Display Results1381380.0463000.0
 (SQL Overall)1786911381.016175877.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.