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

50 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
dimensionless166155(None) 
dimensioned1552463dimension_e_d
dimensions1344613dimension___s
directionless1661933directionless
pensionless1353173__pensionless
tensionless1152673__tensionless
cohesionless1752014cohe_sionless
dimension1244744dimension____
dimensional1453044dimension__al
dimensionality2071524dimensionality
dimensionally1962354dimensionally
dimensioning1652414dimension_ing
pretensionless1661244pretensionless
visionless1342964vi___sionless
affectionless2161875affectionless
ambitionless1661665_ambitionless
compassionless2092105compassionless
defenseless1551895defens__eless
defensiveness20115815defensiveness
dementedness1654675dementedn_ess
denseness1046865d__ens_en_ess
diesinkers1552785di_e_si_nkers
dinginess1137825di__ngi_n_ess
disentitles1255255disenti_tle_s
dissensions12175575dissension___s
distensions12146275distension___s
ditsiness1048145di__tsi_n_ess
diverseness1554775divers_en_ess
diversionist1654515diversion_ist
diversionists1763255diversionists
diversions1446535diversion___s
dressiness1145545d_ressi_n_ess
emotionless1352855_em_otionless
expressionless2361925expressionless
immenseness1553135immens_en_ess
limestones1245015lime_ston_e_s
menseless1145205__mens__eless
mentioners1245345__mention_ers
messiness11248225__messi_n_ess
motionless1243485__m_otionless
passionless1352875__passionless
pensioners1245365__pension_ers
pensiones11410005__pension_e_s
possessionless1471525possessionless
questionless2152005_questionless
reasonless1043525__reas_onless
seasonless1043375__seas_onless
tensioners1044825__tension_ers
timeliness1245305time_li_n_ess
vibrationless1861425vibrationless

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 Limit124790509.47013177.4
3Display Results50500.0331515.2
 (SQL Overall)178691509.64318530.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.