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

82 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
someday134588(None) 
someway1545611someway
comedy14378232comed_y
domesday1542312domesday
somedeal1144572somedeal
someways1644822someways
comedian1347453comedian
comedic14158633comedic
comedo11359603comed_o
comedos12329073comedos
comely134213733come_ly
cometary1547693cometary
cowedly1635693cowedly
domed95423263domed__
domesdays1651593domesdays
doomsday1542003doomsday
dromedary1652073dromedary
forebay1538133forebay
gomeral1038833gomeral
hogmenay1753883hogmenay
holiday1436143holiday
holyday1743773holyday
homeboy1746153homeboy
homed115425423homed__
homely145313173home_ly
homestay1645813homestay
homey135924843home__y
isometry1346113isometry
medal86221323__medal
noonday1144603noonday
nosegay1143843nosegay
notedly1136883notedly
omega836383_omega_
omegas936973_omegas
remedy1237863remed_y
ropeway1544773ropeway
rosebay12135773rosebay
sedan65620423s__edan
sedgy104512783s__edgy
seedy94821533s_eed_y
semidry1345203semidry
shmear1176933shme_ar
sideway1445673sideway
smear74416393s_me_ar
smeary114110803s_meary
smelly114110353s_melly
smudgy13294133s_mudgy
soberly1236943soberly
soda56329383so__da_
sodas64123543so__das
soddy104210703so__ddy
sokeman1337263sokeman
soldan73511853so_ldan
soled65835173soled__
solely93714213sole_ly
solidary1245103solidary
solidly1137353solidly
soma65635293som__a_
soman75024903som__an
somas76030373som__as
somata8312383somata_
somberly1544053somberly
some66040383some___
somebody1642923somebody
somehow1543663somehow
someone938813someone
somewhat1643533somewhat
somital939403somital
sooey84522433sooe__y
sored66141783sored__
sorely94618003sore_ly
sottedly1244303sottedly
soudan73210353so_udan
soundly1136683soundly
sowed94933863sowed__
speedway1743313speedway
speedy1218410783speed_y
steady103510203s_teady
today96416953to__day
womera11137593womera_
womeras1287593womeras
workday1843303workday

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.1561145455.1
2DLD Change Limit134027826.22021547.7
3Display Results82820.0302733.3
 (SQL Overall)178691826.40627894.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.