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 “dwine” 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
dwine9561614(None) 
dine55555331d_ine
dwined114610211dwined
dwines105013101dwines
gwine95513661gwine
swine85625301swine
twine85822361twine
wine74953421_wine
aline57243152aline
amine75835382amine
awing96827322awing
azine146721412azine
bine66650862_bine
brine75132272brine
chine105231722chine
cine66242942_cine
cline76428532cline
dawing114819822dawing
define104718142define
deice84320032deice
dene56643412d_ene
dewing114115702dewing
dice75841892d_ice
die46759652d_i_e
diene65720132diene
dike95935762d_ike
dime76237642d_ime
din46459462d_in_
dined76431992d_ined
diner65632902d_iner
dines66449152d_ines
ding66940952d_ing
dinge75627302d_inge
dink97137802d_ink
dino56036752d_ino
dins56652042d_ins
dint56759052d_int
dire56644142d_ire
dite55547552d_ite
dive85634772d_ive
divine103514462divine
djin12911632djin_
djinn1355632djinn
djins1368452djins
doing74923582doing
domine92918252domine
done55747912d_one
donne65520462donne
dowie94721142dowi_e
dowing114221512dowing
drink106816382drink
drive95318002drive
drone65324982drone
dune56137582d_une
dwindle12415882dwindle
dying105316032dying
dyne85320932d_yne
exine125518492exine
fine75147952_fine
imine75821062imine
kine85643432_kine
koine9516482koine
lawine93316462lawine
line46965572_line
mine67256172_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
urine55026602urine
vine75643682_vine
wane76344722_wane
whine116022812whine
wide85235412_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.406440125.6
2DLD Change Limit538001151.42337807.4
3Display Results1151150.0303833.3
 (SQL Overall)1786911151.85996122.1
 
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.