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

106 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
gwine9551366(None) 
dwine95616141dwine
swine85625301swine
twine85822361twine
wine74953421_wine
aline57243152aline
amine75835382amine
awing96827322awing
azine146721412azine
bine66650862_bine
brine75132272brine
chine105231722chine
cine66242942_cine
cline76428532cline
dine55555332_dine
dwined114610212dwined
dwines105013102dwines
exine125518492exine
fine75147952_fine
gain56042162gain_
gained84617462gained
gainer74117492gainer
gains65729512gains
gamine94620152gamine
gane55145292g_ane
gene56237222g_ene
genie66124922genie
gibe75927782g_ibe
gie47149542g_i_e
gien56330022g_ien
gin46055752g_in_
gink97129522g_ink
gins55543952g_ins
gite55438612g_ite
give85829352g_ive
glide74521592glide
glime85620192glime
glint66830182glint
going75218492going
gone55639042g_one
gride75223582gride
grime85021322grime
grin55733722grin_
grind75917562grind
grins65427222grins
gripe84622962gripe
guide75019882guide
guile64521132guile
guinea737612guinea
guise64717712guise
imine75821062imine
kine85643422_kine
koine9516482koine
lawine93316462lawine
line46965572_line
mine67256162_mine
nine45842172_nine
opine77422462opine
ovine86316642ovine
owing96222722owing
pine67755712_pine
seine55732872seine
shine85533092shine
sine46560622_sine
spine76534422spine
swing96124842swing
swinge105614382swinge
swink125116352swink
swipe105217082swipe
swive115316192swive
thine85026862thine
tine45855132_tine
trine54734602trine
twice104711122twice
twin76023082twin_
twined104413122twined
twiner94012592twiner
twines94717272twines
twinge104210402twinge
twins85118982twins
twiny116012812twiny
urine55026592urine
vine75643682_vine
wane76344712_wane
whine116022812whine
wide85235402_wide
wife105228022_wife
wile75944372_wile
win66456292_win_
wince105220882_wince
wind85533852_wind
wined94434182_wined
wines85546862_wines
winey115325432_winey
wing86339222_wing
wink116435022_wink
wino75933612_wino
wins75949172_wins
winy107034322_winy
winze175014852_winze
wipe94830282_wipe
wire75839812_wire
wise75737342_wise
wite75443272_wite
wive105931752_wive
zine137036152_zine

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 Limit538001061.58034050.6
3Display Results1061060.0303533.3
 (SQL Overall)1786911061.703104927.2
 
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.