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

83 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
ambients124605(None) 
ambient11310091ambient_
absents93510722a_bsents
ambience1455352ambience
ambiences1545252ambiences
ambits103713412ambi__ts
ambiverts1642502ambiverts
aments85219802am__ents
ancients1098972ancients
audients946352audients
abets75621673a_b_e_ts
abluents1045463abluents
absent84016993a_bsent_
accents113511233a_ccents
accidents14155133accidents
advents11309473a_dvents
affiants1445233affiants
agents74816293a__gents
ailments1039433ailments
albinos937653albi_nos
aliens65619213a_lien_s
aliments10311093aliments
ambeers11428923amb_eers
ambers104519583amb_e_rs
ambiance1446063ambiance
ambiances1545713ambiances
ambit94223713ambi__t_
ambivert1545613ambivert_
amblers115213563amble_rs
ambles105121863amble__s
amboinas1246033amboinas
ambones11312683amb_ones
amboynas1543233amboynas
ambries111614553ambrie__s
amends94713283am__ends
amens75624843am__en_s
ament76036543am__ent_
amiantus1044383am_iantus
amies76837693am_ie__s
amines84727983am_i_nes
amins75534323am_i_n_s
ammines11312673ammi_nes
amnions93710913amnion_s
amounts937043am_ounts
amulets939923amule_ts
amylenes13105703amylenes
ancient9514733ancient_
anoints7311063anoi_nts
aperients1178253aperients
argents84014853a_rgents
armaments1347473armaments
aroints7313133aroi_nts
arpents93613083a_rpents
ascents93812553a_scents
assents74512223a_ssents
audient8312303audient_
augments1137833augments
bambinos1443873bambi_nos
bents76033693__b_ents
bints76130183__bi_nts
bionts8612393__bionts
brents84717273__brents
cabinets1238283cabinets
cambists1437023cambi_sts
clients938093_clients
eobionts1043983eobionts
gambiers13337073gambie_rs
gambits12399723gambi__ts
lambent113711303lamb_ent_
lamberts12348793lamb_erts
lambies113015113lambie__s
lambiest122410183lambiest_
laments94314853lam__ents
margents11410133margents
miens76118303_m_ien_s
mints76834043_m_i_nts
moments113113123_moments
orients7311583_orients
patients1088763patients
salients839563salients
sapients1037423sapients
subrents10310293subrents
symbionts1662163symbionts

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 Filter1786911461620.420425454.8
2DLD Change Limit146162837.05020732.2
3Display Results83830.0302766.7
 (SQL Overall)178691837.50023825.5
 
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.