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

115 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
twier8471329(None) 
tier44936141t_ier
trier54328531trier
twiers95410161twiers
twiner94012591twiner
twyer11558521twyer
bier65531832_bier
brier74527402brier
cowier113616162cowier
crier74724462crier
dewier104013462dewier
drier64423962drier
ewer77523982ew_er
flier86023402flier
frier85225842frier
icier74313752icier
kier86526802_kier
lier45942462_lier
osier53518012osier
owner84613312owner
pier66035292_pier
plier75221282plier
prier75027762prier
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sweer84918572sweer
taber73825822taber
tailer63823732tailer
taker95229002taker
taler56034862taler
tamer75230102tamer
taper74829772taper
tater54138612tater
tawer85223442tawer
tawie84819812tawie_
tawnier10318462tawnier
taxer125019362taxer
their85512152their
thewier1336062thewier
thief114516302thief
thir76420542thi_r
tidier73515112tidier
tie36557532t_ie_
tied55535212t_ied
tiers55526522t_iers
ties45248312t_ies
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinier63622232tinier
tire46143352t_ire
titer55430612titer
toiler63918282toiler
toker95924912toker
toner55336242toner
tonier65520712tonier
toper75231022toper
toter55932132toter
tower85729202tower
towie85821872towie_
towies93521192towies
toyer84521552toyer
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
tuber75420682tuber
tuner56022682tuner
tuyer85414292tuyer
twae74719572twae_
twaes86513662twaes
twee76827082tw_ee
tweed94915092tweed
tween84413742tween
tweet84823982tweet
twerp10398412tw_erp
twice104711122twice
twig87615772twi_g
twigs96911172twigs
twill85612722twill
twin76023082twi_n
twine85822362twine
twined104413122twined
twiners10459632twiners
twines94717272twines
twinier1037312twinier
twins85118982twins
twiny116012812twiny
twirl85011942twirl
twirler10285202twirler
twirp10468942twirp
twist86820982twist
twister10308952twister
twit76329062twi_t
twits86015792twits
twitter10278092twitter
twixt155512482twixt
twofer1234352twofer
twyers12497412twyers
tyer75323392t_yer
typier1137332typier
vier75428152_vier
weer75535092_weer
weir76019922_weir
wider94826352_wider
wiper105421292_wiper
wire75839812_wire
wirer85124952_wirer
wiser85522802_wiser
wiver115924512_wiver
wrier84521752wrier

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.0931921408.6
2DLD Change Limit538001151.67332157.8
3Display Results1151150.0303833.3
 (SQL Overall)1786911151.79699493.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.