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

167 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
whine11602281(None) 
chine105231721chine
shine85533091shine
thine85026851thine
wahine123813011wahine
while115418691while
whin105225691whin_
whined134715201whined
whiner124516631whiner
whines125120101whines
whiney155012641whiney
whinge134311531whinge
whins114922331whins
whiny144915571whiny
white114920301white
wine74953421w_ine
ahing98928342ahing
aline57243152aline
amine75835372amine
awhile1257792awhile
azine146721412azine
bine66650852_bine
brine75132272brine
chaine115119222chaine
chide115321012chide
chile105626892chile
chime125322592chime
chin96934742chin_
china105022472china
chined125620062chined
chines115029172chines
chink145321592chink
chino105823312chino
chins105631462chins
chive135117622chive
cine66242942_cine
cline76428532cline
dine55555332_dine
dwine95616142dwine
exine125518492exine
fine75147952_fine
gwine95513662gwine
hide85134622_hide
hie67652702_hi_e
hike116830392_hike
hin67559562_hin_
hind85529752_hind
hinge95323442_hinge
hins76447992_hins
hint77455742_hint
hire75538962_hire
hive106029672_hive
hone77549322_hone
imine75821042imine
kine85643422_kine
koine9516482koine
line46965572_line
mine67256152_mine
nine45842172_nine
ohing96018802ohing
opine77422462opine
ovine86316642ovine
phone105621932phone
pine67755712_pine
rhino84614322rhino
seine55732872seine
shin75634302shin_
shined104620782shined
shiner93820872shiner
shines95028912shines
shins85131042shins
shiny115122142shiny
shire84727132shire
shive114423422shive
shone83725972shone
shrine94920052shrine
sine46560622_sine
spine76534422spine
swine85625302swine
thane86122532thane
theine94814922theine
thin76732382thin_
thing96622962thing
think125018792think
thins85826322thins
tine45855132_tine
trine54734602trine
twine85822362twine
urine55026592urine
vahine123612112vahine
vine75643682_vine
wahines133111172wahines
wain75840192wain_
wains86930862wains
waive114214602waive
wane76344712w_ane
weiner94214132weiner
whale115517432whale
whang124813382whang
whee105429592wh_ee
wheen115016052wheen
when105723042when_
whence14187922whence
whens114618762whens
where117019422where
which163910082which
whid115418872whi_d
whids125413982whids
whiff17310052whiff
whig115516422whi_g
whigs125612642whigs
whiled134514132whiled
whiles124418012whiles
whim126220522whi_m
whims134515332whims
whiners134011572whiners
whinged15409142whinged
whinger1410810902whinger
whinges143610622whinges
whinier134110632whinier
whinny15587492whinny
whip125521842whi_p
whips134917082whips
whipt135317422whipt
whir105519282whi_r
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whi_t
whited134814082whited
whiten124111922whiten
whiter124316392whiter
whites123919882whites
whitey154911882whitey
whits115923822whits
whity145513472whity
whiz195919942whi_z
whizz194210322whizz
whole114418092whole
whore116018042whore
whose114914532whose
wide85235402w_ide
wife105228022w_ife
wile75944372w_ile
win66456292w_in_
wince105220882w_ince
wind85533852w_ind
wined94434182w_ined
wines85546862w_ines
winey115325432w_iney
wing86339222w_ing
wink116435022w_ink
wino75933612w_ino
wins75949172w_ins
winy107034322w_iny
winze175014852w_inze
wipe94830282w_ipe
wire75839812w_ire
wise75737342w_ise
wite75443272w_ite
wive105931752w_ive
wring95920712wring
write85522832write
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 Limit538001671.56334421.0
3Display Results1671670.0762197.4
 (SQL Overall)1786911671.732103170.3
 
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.