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

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

75 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
containerless156206(None) 
containerises1553162containerises
containerise1453973container_ise
containerised1662213containerised
containerizes2462723containerizes
containers1249903container___s
centerless1245004cent___erless
containable1546204containable__
container11311074container____
containerize2363064container_ize
containerized2562114containerized
containerport1771754containerport
containerports1871164containerports
containership2063144containership
containerships2163054containerships
continences1588584cont_inence_s
contriteness1456454contrite_ness
cotterless1244024co_t__terless
curtainless1351934curtain__less
fontanelles1452164fonta_nelle_s
characterless2061425characterless
collarless1243075colla___rless
computerless1852205co_mputerless
conceitedness1875165conceitedness
concierges1544545con_ci_erge_s
conciseness1546665con_cise_ness
confiners1439955con_finer___s
conjoiners1955405conjoiner___s
conniveries1644705con_niverie_s
conominees1445925conomine__e_s
conscienceless177745conscienceless
contactees14135995contacte__e_s
contagiousness1784015contagiousness
contained12310895contain___e_d
containerboard1971005containerboard
containerboards207865containerboards
containerising17201815containerising
containerizing26201875containerizing
containment1557445contain__ment
containments1655785contain_ments
contains10316535contain_____s
contaminates1656315contamin_ate_s
contemners1447075contemner___s
contentedness1655385contentedness
contextless2052485cont__extless
continence1489135cont_inence__
continentals1474305cont_inentals
continents1249565cont_ine__nts
contingences1794995cont_ingence_s
continuers1247945cont_in__uers
continues11310995cont_in__ue_s
contrariness1455485contrarin___ess
contrarinesses1674245contrarinesse_s
contrivers1547255contriver___s
controverters1852465controverters
cordwaineries1961355cordwainerie_s
costiveness1648215cost_ive_ness
costliness1245995costlin___ess
costlinesses1446255costlinesse_s
coverless1436805co____verless
dinnerless1152715din___nerless
fontanelle1352265fonta_nelle__
fontanels1244065fonta_ne_l__s
linerless936335____linerless
mannerless1243525___mannerless
mortarless1243105morta___rless
motherless1544095mo_t__herless
motiveless1542965mo_t_ive_less
mountaineers14122505mountaine__ers
obtainers1144855_obtainer___s
outsiderness1351735_outsiderness
partnerless1351875part__nerless
stainless9176495__stain__less
stairless9185625__stai__rless
taintless935735___tain_tless

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790759.22013534.7
3Display Results75750.0461630.4
 (SQL Overall)178691759.40618997.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.