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 “whinnies” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

188 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
whinnies1423728(None) 
hinnies103615111_hinnies
shinnies113010921shinnies
whinnied15284161whinnied
whinnier14255011whinnier
whinniest15245141whinniest
hinnied11348112_hinnied
minnies93617362_minnies
ninnies73713612_ninnies
pinnies93318442_pinnies
shannies113411262shannies
shindies122610502shindies
shinnied12345832shinnied
spinnies103210542spinnies
whimsies1635192whimsies
whines125120102whi_n_es
whinges143610632whi_nges
whinier134110632whi_nier
whiniest14298752whi_niest
whininess1535132whininess
whirlies14167372whirlies
whirries14136702whirries
whiskies1835952whiskies
whities133113252whi_ties
wienies102213682w_ienies
bennies93917313_bennies
bhisties1339003bhisties
blennies1056933blennies
brinies93317913bri_nies
brionies10310543brionies
bunnies94415003_bunnies
chanties132615803chanties
chilies124218303chi_lies
chillies134113483chillies
chinches18369373chinches
chines115029173chi_n_es
chinkier17377363chinkier
chinkiest1867023chinkiest
chinned134810503chinn_ed
chinning14329653chinning
chinones13510483chinones
chintses1337113chintses
chintzes2235973chintzes
chippies17309763chippies
chitties13310773chitties
chivies153412853chi_vies
chivvies1954423chivvies
crannies10313013crannies
dainties9312403dainties
dingies93618243_dingies
dinkies123716033_dinkies
fannies103415643_fannies
finnier10319953_finnier
finniest113011403_finniest
funnies104113603_funnies
ghillies12408663ghillies
ginnier8298983_ginnier
ginniest92610513_ginniest
grannies9312613grannies
gunnies83413123_gunnies
hankies143617763_hankies
heinies102514543_heinies
henries102718283_henries
hickies163614743_hickies
hinges105121033_hi_nges
hinkier143610793_hinkier
hinkiest153311753_hinkiest
hippies142813753_hippies
hissies103915823_hissies
hongies112716473_hongies
honkies143015143_honkies
hunkies143214503_hunkies
indies73822783__indies
jennies143511623_jennies
jinnis13489053_jinni_s
johnnies1872993johnnies
lindies8416583_lindies
meinies92516073mei_nies
nannies73015203_nannies
pennies94218813_pennies
phonies123717513ph_onies
pinkies133818263_pinkies
quinines172410203quinines
quinsies1737623quinsies
shandies122714113shandies
shanties113116593shanties
sheenies111411543sheenies
shimmies15287803shimmies
shindigs13284203shindigs
shines95028913shi_n_es
shingles123111113shingles
shinier104113143shi_nier
shiniest113212503shi_niest
shininess1237343shininess
shinned114310923shinn_ed
shinneries1345723shinneries
shinney13368303shinn_ey
shinneys14275103shinneys
shinning123211023shinning
skinnier1264893skinnier
skinniest1335523skinniest
sonnies7315223_sonnies
squinnies1844483squinnies
tennies73017973_tennies
thinned11399173thinn_ed
thinner10358983thinn_er
thinners11327763thinners
thinness11277173thinness
thinnest11248903thinn_est
thinning12319093thinning
thinnish1454883thinnish
thionines12106973thionines
thionins1177923thionins
thirties1139723thirties
tinnier72910143_tinnier
tinniest82911463_tinniest
trannies8415013trannies
tunnies73614263_tunnies
twinkies1535983twinkies
wahines133111173wahi_n_es
weenies102915093w_eenies
weirdies12255783weirdies
wennier10318603w_ennier
wenniest11259593w_enniest
whammies18265513whammies
whangees15275063whangees
wheelies1437873wheelies
wherries14179033wherries
whiffles2034263whiffles
whiles124418013whi__les
whimsied1743113whimsied
whine116022813whi_n_e_
whined134715203whi_n_ed
whiner124516633whi_n_er
whiners134011573whi_ners
whiney155012643whi_n_ey
whinge134311543whi_nge_
whinged15409153whi_nged
whinger1410810913whi_nger
whingers15358723whingers
whinging16247743whinging
whining143311673whi_ning
whinny15587493whinn__y
whinnying19172733whinnying
whins114922333whi_n__s
whippier18265823whippier
whippiest19265123whippiest
whirlier14175293whirlier
whirliest15216043whirliest
whirried15154113whirried
whishes16309443whi_shes
whistles14108213whistles
whites123919883whi__tes
whitier133311063whi_tier
whitiest14259883whi_tiest
whitings15287063whitings
whittles1496673whittles
whizzes2134713whi_zzes
whizzier2233283whizzier
whizziest2342883whizziest
whoopies16267373whoopies
widdies123514033w_iddies
wienie9229973w_ienie_
willies103920153w_illies
winces114819113w_i_nces
winches154714373w_inches
windier113412163w_indier
windiest122213233w_indiest
windles113518493w_indles
wineries112316533w_ineries
wines85546863w_i_n_es
wingier113413283w_ingier
wingiest123214283w_ingiest
winier94522453w_i_nier
winiest103419693w_i_niest
winkles143412773w_inkles
winned104017013w_inn_ed
winner94219933w_inn_er
winners104316913w_inners
winning113516553w_inning
winnings12327583w_innings
winnows1334533w_innows
winoes94317013w_i_noes
wintles103414983w_intles
winzes184313053w_i_nzes
withies133913543w_ithies
wrinkles15296693wrinkles
zinnias1635863_zinnias

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621887.04620744.0
3Display Results1881880.0802350.0
 (SQL Overall)1786911887.54923670.8
 
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.