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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

82 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
shri76021701shri
haj138140602_haj
sard55344242sard
sari45444042sari
sark84938972sark
scry96017762scry
ser36752402ser_
sera46141392sera
sere46153472sere
serf76340112serf
sers45746652sers
sh56828522sh__
sha69837782sh_a
shad86230912shad
shag86430562shag
shah105627782shah
sham96436362sham
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456602shat
shaw108132552shaw
shay107133342shay
she66837692sh_e
shea76031572shea
shed86536152shed
sherd96321152sherd
shes75734352shes
shew108030762shew
shh97121072sh_h
shim95827862shim
shin75634312shin
ship95228242ship
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shit76745942shit
shiv105721172shiv
shmo95318102shmo
shod86225062shod
shoe75933442shoe
shog86025142shog
shoji15419962shoji
shoo75929892shoo
shop95629842shop
shore85432652shore
shorl84720252shorl
shorn85722182shorn
short85040532short
shot76150262shot
show106229192show
shred98125612shred
shrew119720172shrew
shris84221452shris
shrub104814892shrub
shrug94512512shrug
shul75823152shul
shun75122772shun
shut76137592shut
shwa106014962shwa
shy96728192sh_y
sir35746682sir_
sire46150422sire
sirs44338342sirs
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sori46039842sori
sorn46641062sorn
sort46264812sort
spry96819122spry
sri35634002s_ri
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
thro77726422thro
thru76818942thru

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 Filter178691298721.190150160.5
2DLD Change Limit29872824.3136926.0
3Display Results82820.0461782.6
 (SQL Overall)178691825.54932202.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.