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

78 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
rebottled124343(None) 
rebottle1044341rebottle_
rebottles1143871rebottles
bottled104611232__bottled
reboiled11349392rebo_iled
rebooted11248462reboot_ed
rebutted11126782rebutt_ed
repotted1139282repott_ed
resettled1035302resettled
retotaled1045952retotaled
unbottled1244152unbottled
battled104213123__battled
bedotted1234983bedott_ed
belittled1243033belittled
besotted1135843besott_ed
bottle84916073__bottle_
bottler94211883__bottler
bottles94216273__bottles
embattled1442563embattled
fettled11378933fe__ttled
mettled103510543me__ttled
mottled10409973__mottled
nettled8339943ne__ttled
pettled103611513pe__ttled
prebattle1343013prebattle_
preboiled1455783prebo_iled
presettled1344083presettled
rattled84012953r__attled
rebaited11410543rebait_ed
rebated103619703reb_at_ed
rebelled113110323reb_elled
rebilled11318053reb_illed
reboarded1365613reboarded
rebodied1237243rebo_died
rebooked15226503rebo_oked
rebored105015883rebo__red
rebottling1343733rebottling
rebounded1335463rebounded
rebutter10106273rebutt_er
rebuttoned1351963rebuttoned
recoaled113111783reco_aled
recoated113416783recoat_ed
recoiled113613213reco_iled
recoupled1496163recoupled
redoubled1343773redoubled
refitted12309413refitt_ed
reknotted1443523reknott_ed
remitted113312073remitt_ed
remodeled1344723remodeled
reoiled84316853re_o_iled
replotted1235823replott_ed
repolled11359623repo_lled
reported11312703report_ed
rerolled93010053rero_lled
rerouted9311143rerout_ed
resettle837303resettle_
resettles936563resettles
resoled84119283reso__led
resorted9313493resort_ed
respotted1235953respott_ed
restyled1236943re_styled
retiled84420513re__tiled
retitled9339553re_titled
retooled938473reto_oled
retorted9312333retort_ed
retotalled1143623retotalled
retted74826313re__tt_ed
revetted122210943revett_ed
revolted12319863revolt_ed
revoted114314153revo_t_ed
rewetted12228353rewett_ed
robotized2144613robotized
rootled83410533r__ootled
rotted74524433r__ott_ed
settled83210873se__ttled
throttled1352963throttled
unbottle1044223unbottle_
unbottles1143463unbottles

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.470380193.6
2DLD Change Limit148641787.17020731.0
3Display Results78780.0332363.6
 (SQL Overall)178691787.67323288.3
 
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.