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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
relocatable154286(None) 
allocatable1551962allocatable
locatable1345572__locatable
relatable11310052rel__atable
delectable15247373delec_table
detonatable1462493detonatable
electable13149623_elec_table
floatable1444983_flo_atable
redoubtable1652123redoubtable
relaxable1836363rel__axable
releasable1245483rel_easable
relocate10713533relocat___e
relocatee11810623relocat__ee
repeatable1447603re_peatable
reportable1446953repo_rtable
resectable1478123resec_table
retractable1545123retractable
revocable1647003revoc__able
rotatable1146653r__otatable
selectable14136443selec_table
allocable1345634alloc__able
automatable1552854automatable
beatable121612244be___atable
blockable1944304_bloc_kable
boatable121610264__bo_atable
chelatable1743604chel__atable
creatable1339564cre___atable
debatable1446314de__batable
decayable1745624de__cayable
deflectable1943804deflec_table
delayable1546064del__ayable
delectables16144334delec_tables
delectably18125684delec_tably
deletable12149504del__etable
demountable1652574demountable
denotable1238374deno__table
deportable1545654depo_rtable
detectable15136594detec_table
dilatable1246854dil__atable
eatable91717604_e___atable
ejectable20136574_ejec_table
enactable1338494_enac_table
equatable2045194_e_quatable
erectable131210094_erec_table
escapable1544984_e_scapable
evocable1537104_evoc__able
exactable2046434_exac_table
excitable2056244_e_xcitable
executable2144034_executable
getatable1235954ge__tatable
heatable131612044he___atable
ineluctable1545394ineluc_table
isolatable1244374_isolatable
loanable1037614__lo_anable
lockable1636954__loc_kable
meltable12310474mel___table
palatable1346374pal__atable
predictable1844984predic_table
prelocate13109514prelocat___e
ratable91717554r____atable
reachable16129654re_ac_hable
readable11313164re___adable
reapable12311394re___apable
rebuttable1443944re_buttable
recallable1445374re__callable
recappable1843724re__cappable
reclosable1444894reclo__sable
reconcilable1853394reconcilable
recordable1545554reco_rdable
recoupable1645024reco_upable
recoverable1853764recoverable
recyclable1943644recyc_lable
redoubtably1951484redoubtably
reformable1745294refo_rmable
refutable1477864re__futable
regrettable1452984regrettable
rehydratable215764rehydratable
relegable1258104rel__egable
reliable10313074rel___iable
relievable1544664rel_ievable
relishable1544524rel_ishable
relivable1438514rel__ivable
relocated12710814relocat__ed
relocatees1275214relocat_ees
relocates11712924relocat__es
relocating13310874relocat_ing
relocation12312114relocat_ion
relocations13311134relocations
reluctance14114284reluc_tance
reluctate1146914reluc_ta_te
remittable1445734re_mittable
removable1646924remo__vable
removeable1744224remo_veable
rentable101716334re___ntable
reparable1359954re__parable
repayable1666344re__payable
repealable1445984re_pealable
replaceable1743224replac_eable
replicable1646624replic__able
reproachable2152614reproachable
reputable1379124re__putable
resalable1138734re__salable
rescuable1347584re_sc_uable
resealable1246184re_sealable
resettable1256504re_settable
resolvable1544584reso_lvable
respectable1755044respectable
restable101618434re___stable
restartable1343544restartable
retable91820404re____table
revealable1545084re_vealable
revocably1944574revoc__ably
revokable1845294revo__kable
revolvable1843514revo_lvable
rockable1638014r__oc_kable
treatable1139324tre___atable
unelectable1546744unelec_table
vacatable1644644__vacatable

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 Limit1488191189.26616060.8
3Display Results1181180.0601966.7
 (SQL Overall)1786911189.48218845.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.