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

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

51 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
nurturances135243(None) 
nurturance1252521nurturance_
furtherances2052013furtherances
nurturant964853nurturan__t
nurtures837443nurtur___es
outrances112912113ou_t_rances
pursuances1443453pursu_ances
purtenances1553863purtenances
utterances1245083_utterances
assurances1244694_assurances
cumbrances1844214cu_mbrances
disturbances1752454disturbances
durances1158684___durances
endurances1344934_endurances
entrances11310954_ent_rances
fragrances1643884_fragrances
furfurans1562374furfuran__s
furtherance1951844furtherance_
insurances1246854_insurances
iterances1148904__iterances
luxuriances2051754lu_xuriances
nocturnes1143854noctur_n_es
nuances938524n___u_ances
nudibranchs196774nudibranchs
nuisances1145334nu__isances
nurtural845494nurtura___l
nurture736644nurtur___e_
nurtured935254nurtur___ed
nurturer844474nurtur___er
nurturers943354nurtur__ers
nurturing1045014nurturin__g
nutgrasses1143434nu_tgrasses
outdances12198504ou_t_dances
outraces102217864ou_t_ra_ces
outrance102212774ou_t_rance_
outranges102510014ou_t_ranges
petulances1444294_petulances
portances1349834port__ances
pursuance1344094pursu_ance_
purtenance1454054purtenance_
purulences1444504pur_ulences
purveyances2152064purveyances
quittances2143204quit_tances
securances1445744_securances
sufferances1953374sufferances
survivances1952164survivances
sustenances1353624sustenances
trances93919644___t_rances
turbulences1552614turbulences
undulances1343374_undulances
utterance1145454_utterance_

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit148819519.11016335.8
3Display Results51510.0133923.1
 (SQL Overall)178691519.27919257.6
 
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.