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

95 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
winesap126444(None) 
pinesap1164721pinesap
winesaps1364551winesaps
winesop1264231winesop
pinesaps1253982pinesaps
wines85546862wines__
wineshop1643762wineshop
winesops1374662winesops
wiretap12145722wiretap
bines76946793bines__
cineast9310523cineast
cinema1047653cinema_
cinemas1138043cinemas
cines75239683cines__
dines66449153dines__
dwines105013103dwines__
fines86644263fines__
finesse10187643finesse
finest94321733fines_t
icecap1245223_icecap
inseam8329993_inseam
inwrap11115903_inwrap
kinema1236023kinema_
kinemas1336893kinemas
kines95039133kines__
kineses113111253kineses
kinesic13257023kinesic
kinesis11259593kinesis
lineal65616023line_al
linear65113343line_ar
lineman939123lineman
lines57054573lines__
linesman1046253linesman
lineup835983line_up
mineral9312733mineral
mines75651953mines__
neap66927013__ne_ap
nines55937343nines__
pineal84817683pine_al
pines76048863pines__
pineta85815563pineta_
sines55954823sines__
sneap75514823_sne_ap
tinea54923163tine_a_
tineal66216163tine_al
tineas64616483tine_as
tines54848423tines__
twines94717273twines__
vineal94814743vine_al
vinegar1134613vinegar
vines85137643vines__
wanes85040883wanes__
whines125120103whines__
whitecap1842713whitecap
wides94832823wides__
widest104517003wides_t
wifes114522563wifes__
wiles85437873wiles__
winces114819113winces__
windbag1444123windbag
winds95425603winds__
windup1235383win_dup
windway1745153windway
wine74953423wine___
wined94434183wine__d
winery125014283wine_ry
wineshops1743963wineshops
wineskin1544243wineskin
winey115325433wine__y
wingman1336383wingman
wings95727243wings__
wingspan1442793wingspan
wingtip1343613wingtip
winiest103419693winies_t
winish124212263winis_h
winks125325433winks__
winless103212283winles_s
winoes94317013winoes__
winos84625043winos__
wins75949173win_s__
winzes184313053winzes__
wipes104827083wipes__
wireman1237843wireman
wires86034913wires__
wiretaps13144733wiretaps
wireway1646043wireway
wiseass1035823wiseass
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.406440125.6
2DLD Change Limit134027956.47020715.1
3Display Results95950.0303166.7
 (SQL Overall)178691956.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.