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 “unbottled” 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
unbottled124415(None) 
unbottle1044221unbottle_
unbottles1143461unbottles
bottled104611232__bottled
rebottled1243432rebottled
unbitted1138212unbitt_ed
unboiled112410372unbo_iled
unbolted1179322unbolt_ed
unbooted1188772unboot_ed
undotted1048522undott_ed
unpotted11108392unpott_ed
unsettled1055212unsettled
battled104213123__battled
bottle84916073__bottle_
bottler94211883__bottler
bottles94216273__bottles
embattled1442563embattled
knotted12357233kn_ott_ed
mottled10409973__mottled
nettled8339943_n_ettled
rebottle1044343rebottle_
rebottles1143873rebottles
throttled1352963throttled
unabetted1244993unabett_ed
unaborted1245733unabort_ed
unbaled103315963unb__aled
unbasted112510073unbast_ed
unbated103317733unb_at_ed
unbathed1437223unb_athed
unbelted1179333unbelt_ed
unbilled1188693unb_illed
unbitten1045213unbitt_en
unbitter1046173unbitt_er
unboarded13185683unboarded
unbobbed1234413unbo_bbed
unbodied1237263unbo_died
unbonded12299763unbo_nded
unboned103014223unbo__ned
unbosomed1464253unbosomed
unbottling1343133unbottling
unbounded1335413unbounded
unbowed132610243unbo__wed
unboxed17249573unbo__xed
unbridled1344973unbridled
unbroiled1235803unbroiled
unbuckled1843633unbuckled
unbundled1344103unbundled
unbusted11258773unbust_ed
unbuttered1353133unbuttered
unbuttoned1341993unbuttoned
uncoated11314963uncoat_ed
uncobbled1643663uncobbled
uncoiled112512683unco_iled
uncooled112710633unco_oled
uncoupled1445703uncoupled
undoubled1344233undoubled
unfitted1238163unfitt_ed
unfoiled12249723unfo_iled
ungotten944533ungott_en
unhatted1238183unhatt_ed
unknotted1443623unknott_ed
unletted9310313unlett_ed
unmatted1138293unmatt_ed
unnoted8311363unno_t_ed
unnoticed1243923unnoticed
unoiled82415483un_o_iled
unpitted1148623unpitt_ed
unpolled1168943unpo_lled
unposted1159433unpost_ed
unrolled9610413unro_lled
unrooted9810513unroot_ed
unsettle866063unsettle_
unsettles964653unsettles
unsoiled92412083unso_iled
unsoothed1344253unsoothed
unsorted9312513unsort_ed
unspotted1244933unspott_ed
untitled978763un_titled
unwetted1238123unwett_ed
unwitted1237543unwitt_ed
unwonted12248643unwont_ed
upboiled13194853upbo_iled

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641826.84321721.6
3Display Results82820.0332484.8
 (SQL Overall)178691827.29624491.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.