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

93 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
stirp7681550(None) 
stir45723251stir_
stirk95717411stirk
stirps85011821stirps
stirs55921621stirs
strip77524341strip
astir55517092astir_
atrip75315752atrip
chirp124717162chirp
satire63218002satire
scarp95724102scarp
scrip96619192scrip
sharp104922532sharp
ship95228242shi_p
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
simp85228772s_imp
sip57656012s_i_p
sir35746672s_ir_
sire46150412s_ire
sirs44338332s_irs
sirup74014912s_irup
situp74414062situp
skimp135411322skimp
skip105421752ski_p
skirl96012912skirl
skirr94810542skirr
skirt95624662skirt
slip67031732sli_p
slurp74014982slurp
smirk116612752smirk
snip66424652sni_p
spire75828692spire
spirt75032952spirt
spiry105017352spiry
stair54719942stair_
stairs65416332stairs
stamp95217362stamp
star48037762star_
stare54440262stare
stark95425622stark
stars55836572stars
start55642312start
steep76020702steep
step67126292st_ep
stere55328542stere
stern55319122stern
stich104117922stich
stick115121562stick
stied65723032stied
sties55132982sties
stiff114219242stiff
stile54931572stile
still54922082still
stilt54831982stilt
stime76521802stime
stimy105114742stimy
sting65330242sting
stink95122502stink
stint57037662stint
stipe76523372stipe
stirks104914242stirks
stirpes95011292stirpes
stirrup943002stirrup
stomp95616662stomp
stoop75821542stoop
stop66532032st_op
store56333812store
stork96819692stork
storm76520402storm
story86723032story
stoup75517072stoup
stowp105614232stowp
strap77925262strap
strep77120852strep
stria55723212stria
stripe85822442stripe
strips85719652strips
stript85222192stript
stripy115812742stripy
strop77422242strop
stump94616462stump
sturt56028962sturt
swirl84514142swirl
tarp66936422_tarp
tip56551222_ti_p
tire46143352_tire
tirl45029922_tirl
tiro46832362_tiro
trip66830392_trip
twirp10468942twirp

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 Filter178691538000.296603685.8
2DLD Change Limit53800931.59333772.8
3Display Results93930.0332818.2
 (SQL Overall)178691931.92292971.4
 
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.