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

185 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
thine8502686(None) 
chine105231721chine
shine85533091shine
thane86122531thane
theine94814921theine
thin76732391thin_
thing96622981thing
think125018801think
thins85826331thins
tine45855131t_ine
trine54734601trine
twine85822361twine
whine116022811whine
ahing98928352ahing
aline57243152aline
amine75835382amine
azine146721412azine
bine66650862_bine
brine75132272brine
chaine115119222chaine
chide115321012chide
chile105626892chile
chime125322592chime
chin96934742chin_
china105022482china
chined125620062chined
chines115029172chines
chink145321592chink
chino105823312chino
chins105631462chins
chive135117622chive
cine66242942_cine
cline76428532cline
dine55555332_dine
dwine95616142dwine
ethane94613242ethane
ethene93312922ethene
ethyne12407152ethyne
exine125518492exine
fine75147952_fine
gwine95513662gwine
hide85134642_hide
hie67652702_hi_e
hike116830392_hike
hin67559562_hin_
hind85529752_hind
hinge95323452_hinge
hins76447992_hins
hint77455742_hint
hire75538962_hire
hive106029672_hive
hone77549322_hone
imine75821062imine
kine85643432_kine
koine9516482koine
line46965572_line
mine67256172_mine
nine45842172_nine
ohing96018812ohing
opine77422462opine
ovine86316642ovine
phone105621932phone
pine67755712_pine
rhino84614322rhino
seine55732872seine
shin75634312shin_
shined104620782shined
shiner93820872shiner
shines95028912shines
shins85131042shins
shiny115122142shiny
shire84727132shire
shive114423422shive
shone83725982shone
shrine94920052shrine
sine46560622_sine
spine76534422spine
swine85625302swine
tahini939892tahini
tain45548072tain_
tains54936322tains
taint55542282taint
teind6213612teind
terne56426152terne
thae76825562th_ae
than76128772than_
thanes94918982thanes
thank125817802thank
the67436052th__e
thebe107515432thebe
thee78039062th_ee
thein85919022thein_
theines104013232theines
theins95015422theins
theme105921732theme
then78429692then_
thence112010852thence
thens85921832thens
there87527392there
these86519012these
thick145613352thick
thief114516302thief
thieve1235962thieve
thigh12410122thigh
thill85918732thill
things104914302things
thinker143610682thinker
thinks134613362thinks
thinly1238672thinly
thinned11399172thinned
thinner10358982thinner
thio77225412thi_o
thiol87616042thiol
thir76420542thi_r
third95912492third
thirl85416822thirl
this76027382thi_s
thole85620842thole
thong95014182thong
those85218142those
three87526912three
thrice114311572thrice
thrive125313222thrive
throe89321422throe
throne98517602throne
thunk124911852thunk
thyme134612472thyme
thymine1536642thymine
tide55237382t_ide
tie36557532t_i_e
tike85534482t_ike
tile45451442t_ile
time66235012t_ime
tin36362172t_in_
tinea54923162t_inea
tined65434532t_ined
tines54848422t_ines
ting56139912t_ing
tinge64626632t_inge
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
tire46143352t_ire
toile54626492toile
tone46953742t_one
tonne54921432tonne
toxine133114122toxine
tribe74420272tribe
trice75127492trice
triene64316382triene
trike95320162trike
trined74920712trined
trines64132562trines
tripe75425382tripe
trite54730032trite
triune64210182triune
trone55131862trone
tune45635862t_une
twice104711122twice
twin76023082twin_
twined104413122twined
twiner94012592twiner
twines94717272twines
twinge104210402twinge
twins85118982twins
twiny116012812twiny
tyin76424002tyin_
tying96019842tying
tyne76325052t_yne
urine55026602urine
vahine123612112vahine
vine75643682_vine
wahine123813012wahine
while115418692while
whin105225692whin_
whined134715202whined
whiner124516632whiner
whines125120102whines
whiney155012642whiney
whinge134311542whinge
whins114922332whins
whiny144915572whiny
white114920302white
wine74953422_wine
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.343520965.0
2DLD Change Limit538001851.46636698.5
3Display Results1851850.0464021.7
 (SQL Overall)1786911851.85596329.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.