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

90 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
familiarnesses197178(None) 
familiarness1772052familiarne_s_s
familiarises1753123familiar__ises
dailinesses1249494da_ili__nesses
facilenesses1756724facil__enesses
fairnesses1357384fa___i_rnesses
familiarise1653404familiar__ise_
familiarised1862414familiar__ised
familiarities1852864familiar_ities
familiarizes2652984familiar__izes
femininenesses1952994femininenesses
agilenesses1247785_agil__enesses
aimlessnesses1487465_aimlessnesses
airinesses102613635_a_iri__nesses
aliennesses1145865_a__liennesses
alikenesses1547205_a__likenesses
alivenesses1448875_a__livenesses
amativenesses1856785_amativenesses
amiablenesses1756535_amiablenesses
amplenesses1585705_ampl__enesses
amusingnesses1652845_amusingnesses
campinesses1737115cam_pi__nesses
clearnesses13106155___clearnesses
comelinesses1666405comeli__nesses
dailynesses1543945da_il__ynesses
darlingnesses1563055da_rlingnesses
devilishnesses2152695devilishnesses
earlinesses11311055ea_rli__nesses
fabulousnesses1954705fabulousnesses
facelessnesses1847325facelessnesses
factualnesses1853695fa_ctualnesses
faddishnesses2143245fa_ddishnesses
faintishnesses2053305faintishnesses
faintnesses1447145fa___intnesses
fallownesses1852375fa__llownesses
falsenesses1446745fa__l_senesses
familiarising19142145familiar_ising
familiarize2553145familiar__ize_
familiarized2752525familiar__ized
familiars1464755familiar_____s
famousnesses1745715fam__ousnesses
fanaticalnesses2082315fanaticalnesses
fancinesses1638145fa_nci__nesses
farnesses122310815f_____arnesses
fatalnesses1456285fa___talnesses
fattinesses14118975fa_tti__nesses
faultinesses1545185fa_ul_tinesses
feelingnesses1753515f_eelingnesses
femalenesses1746865femal__enesses
filminesses1636245f__il_minesses
filthinesses1844465f__ilthinesses
finicalnesses1853835fini_calnesses
finitenesses1557725f__initenesses
flatnesses1337765f___l_atnesses
flimsinesses1744005flimsi__nesses
foaminesses1658075foam__i__nesses
foolishnesses1944465f_oolishnesses
frailnesses1447605frail___nesses
frigidnesses1743645f_rigi_dnesses
fruitinesses1546445fruiti__nesses
fugitivenesses2154455fugitivenesses
futilenesses1547215futil__enesses
gaminesses13410465gam__i__nesses
habitualnesses1962215habitualnesses
hairinesses14198945ha_iri__nesses
hamminesses1835775ham_mi__nesses
homelinesses1765365homeli__nesses
initialnesses1395625_initialnesses
manlinesses13910195ma_nli__nesses
materialnesses1653915materialnesses
mildnesses1397395__mil__dnesses
militantnesses1661875__militantnesses
milkinesses1786795__mil_kinesses
minidresses1443285__minidr_esses
mirinesses121512325__miri__nesses
mulishnesses1755095__mulishnesses
namelessnesses1577055namelessnesses
oilinesses101512445__oili__nesses
palatialnesses1653395palatialnesses
pallidnesses1543925pa_lli_dnesses
radicalnesses16124145radi_calnesses
raininesses11310505ra_ini__nesses
rationalnesses1452635rationalnesses
semidarknesses2161295semi_darknesses
timelinesses1445455timeli__nesses
valiantnesses1652725va__liantnesses
validnesses1576025va__li_dnesses
villainesses1543515__villainesses
wildernesses1643625__wildernesses
wilinesses131911095__wili__nesses

Search took 7 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 Filter178691950240.373479064.3
2DLD Change Limit95024906.09315595.6
3Display Results90900.0631428.6
 (SQL Overall)178691906.52927368.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.