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

101 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
shirr8471692(None) 
chirr105015901chirr
shier85428941shier
shire84727131shire
shirk124817841shirk
shirrs94413171shirrs
shirt84533901shirt
skirr94810541skirr
whirr114611191whirr
ashier94714832ashier
birr66022362_birr
charr104821782charr
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirre114111852chirre
chirrs114514982chirrs
chiru105317152chiru
churr104512852churr
hire75538962_hire
hirer85423122_hirer
shaird10288702shaird
shairn9269062shairn
shard96125962shard
share86437082share
sharer95025482sharer
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shear85424832shear
sheer84726892sheer
sherd96321152sherd
sherry124510412sherry
shied96125492shied
shiel811023772shiel
shiers94921752shiers
shies86136552shies
shift114225142shift
shikar1336802shikar
shill85325332shill
shily115222012shily
shim95827862shi_m
shims104422552shims
shin75634312shi_n
shine85533092shine
shiner93820872shiner
shins85131042shins
shiny115122142shiny
ship95228242shi_p
ships105123772ships
shires95225572shires
shirker143711342shirker
shirks134814122shirks
shirred113710502shirred
shirts94918342shirts
shirty124312562shirty
shist84829612shist
shit76745942shi_t
shits84731172shits
shiv105721172shi_v
shiva115915002shiva
shive114423422shive
shiver124517372shiver
shivs115018802shivs
shoer84722162shoer
shore85432652shore
shorl84720252shorl
shorn85722182shorn
short85040532short
shri76021702sh_ri
shris84221452shris
shyer114714782shyer
sir35746672s_i_r
sire46150412s_ire
sirra54416322s_irra
sirs44338332s_irs
skier95119592skier
skirl96012912skirl
skirrs10448192skirrs
skirt95624662skirt
slier54827242slier
smirk116612752smirk
spier75728032spier
spire75828692spire
spirt75032952spirt
spiry105017352spiry
stir45723252sti_r
stirk95717412stirk
stirp76815502stirp
stirs55921622stirs
swirl84514142swirl
thir76420542thi_r
third95912492third
thirl85416822thirl
whir105519282whi_r
whirl114913822whirl
whirrs12408592whirrs
whirry15477062whirry
whirs115218092whirs
yirr76513572_yirr

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 Filter178691538000.436409841.7
2DLD Change Limit538001012.81319125.5
3Display Results1011010.0631603.2
 (SQL Overall)1786911013.31253952.6
 
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.