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

69 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
observe124532(None) 
observed1444371observed
observer1344721observer
observes1346161observes
conserve1339922conserve
deserve11108702deserve
observers1443962observers
obverse1234752obverse
outserve11157202outserve
reobserve1442462reobserve
reserve101011202reserve
serve85425962__serve
subserve1346462subserve
absence1137703absence
absolve1244513absolve
absterge1154083absterge
berme96022943_b_erme
boiserie1047993boiserie
breve105317053_bre_ve
caserne93710063caserne
conserved1538853conserved
conserver1448723conserver
conserves14311193conserves
deserved13108133deserved
deserver12118383deserver
deserves12109893deserves
disserve1287443disserve
innerve1056743innerve
nerve86617373__nerve
obese75212423ob_e_se
obscene1145243obscene
obscure1145333obscure
obsecrate1344633obsecrate
obsequy2141863obsequy
observable1743333observable
observance17124033observance
observant1444453observant
observing1544383observing
obsess845943obse_ss
obsessed1144273obsessed
obsesses1036223obsesses
obsessive1443743obsessive
obverses1335803obverses
obvert11412993obver_t
obverted1435103obverted
obverts1235403obverts
outserved13136463outserved
outserves12147373outserves
preserve13108803preserve
reobserved1642393reobserved
reobserves1542623reobserves
reserved121010583reserved
reserver11119633reserver
reserves111011983reserves
sere46153473__ser_e
serge64727473__serge
served104616813__served
server94917713__server
serves94423653__serves
servo84516683__servo
subsere9311443subser_e
subserved1545143subserved
subserves1447183subserves
swerve1256293_swerve
unnerve1066653unnerve
unobserved1642423unobserved
unserved12410233unserved
verve115417723__verve
wherve15568113_wherve

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.440406115.9
2DLD Change Limit134027695.84322938.0
3Display Results69690.0302300.0
 (SQL Overall)178691696.31328305.2
 
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.