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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
shavies13421320(None) 
shaves125224931shav_es
shavie124312421shavie_
spavies123012941spavies
cavies114525002_cavies
chevies153511442chevies
chivies153412852chivies
davies105020512_davies
ghazies2036912ghazies
gravies11314092gravies
haves116034872_hav_es
heavies132713872heavies
mavies114923192_mavies
navies95218622_navies
peavies122213402peavies
sanies63031952s_anies
saves85838632s_av_es
savines104417632s_avines
savins93923132s_avins
savvies1337602savvies
scabies11613332scabies
shades105924532sha_des
shadier113111152shadier
shadiest121711272shadiest
shakes135024592sha_kes
shakier143411152shakier
shakiest151910932shakiest
shakoes144510022shakoes
shales94731252sha_les
shalier103116422shalier
shaliest111415052shaliest
shames114726222sha_mes
shammes144312832shammes
shammies15259682shammies
shandies122714102shandies
shannies113411252shannies
shanties113116582shanties
shapes115124942sha_pes
shares95236412sha_res
sharias102516002sharias
sharifs13279902sharifs
sharpies13411222sharpies
shave114425892shav_e_
shaved135118382shav_ed
shaven124213302shav_en
shaver123718912shav_er
shavers134115092shavers
shaving143414332shaving
shavings15356332shavings
sheaves134412972sheav_es
shies86136552sh__ies
shives124921412shiv_es
shoves124919422shov_es
shrives134416172shrives
slaves95023022slav_es
soaves94218672soav_es
spavie113611382spavie_
spaviet123011922spaviet
spavins12419322spavins
staves94525192stav_es
swamies123712062swamies
wavies125019842_wavies

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit107671623.04635348.3
3Display Results62620.0331878.8
 (SQL Overall)178691623.46951510.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.