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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
winesop126423(None) 
winesap1264441winesap
wineshop1643761wineshop
winesops1374661winesops
pinesap1164722pinesap
wines85546862wines__
winesaps1364552winesaps
wineshops1743962wineshops
bines76946793bines__
cineol8108203cine_ol
cines75239683cines__
dinero75612643dinero_
dineros83812333dineros
dines66449153dines__
dwines105013103dwines__
fines86644263fines__
finesse10187643finesse
finest94321733fines_t
kines95039133kines__
kinescope1744183kinescope
kineses113111253kineses
kinesic13257023kinesic
kinesis11259593kinesis
lines57054573lines__
lineup835983line_up
milksop1542833milksop
mines75651953mines__
netop7312343__netop
nines55937343nines__
pines76048863pines__
pinesaps1253983pinesaps
sines55954823sines__
swinepox2041123swinepox
tines54848423tines__
twines94717273twines__
vines85137643vines__
wanes85040883wanes__
whines125120103whines__
wides94832823wides__
widest104517003wides_t
wifedom1643553wifedom
wifes114522563wifes__
wigeon1037223wige_on
wiles85437873wiles__
winces114819113winces__
window1347363win_dow
windrow1445853windrow
winds95425603winds__
windsock1843183windsock
windup1235383win_dup
wine74953423wine___
wined94434183wine__d
winery125014283wine_ry
wineskin1544243wineskin
winey115325433wine__y
wingbow1643773wingbow
wings95727243wings__
wingtip1343613wingtip
winiest103419693winies_t
winish124212263winis_h
winks125325433winks__
winless103212283winles_s
winnow1234593win_now
wino75933613win__o_
winoes94317013winoes__
winos84625043win__os
wins75949173win_s__
winsome1237463win_some
winzes184313053winzes__
wipes104827083wipes__
wires86034913wires__
wiretap12145723wiretap
wises85633193wises__
wisest95016443wises_t
wisp97124073wi__s_p
wites85536963wites__
witness103010013witnes_s
wives115328923wives__
wizes174723343wizes__
zines145232653zines__

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit134027806.45320769.7
3Display Results80800.0332424.2
 (SQL Overall)178691806.90625874.7
 
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.