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

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

49 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
superalloys166307(None) 
superalloy1544441superalloy_
permalloys1751833__permalloys
superably1648883superabl_y_
superatoms1448393supera_toms
superfluous1663163superfluous
supernally1546773supernall_y_
numerally1446134numerall_y_
permalloy1643024__permalloy_
preallots1144514__preallots
severally1546244severall_y_
spirally1348024s_pirall_y_
superable13312484superabl__e
superadds1346414supera__dds
superagents14117514superagents
superaltern1354744superaltern
superalterns1453884superalterns
superatom1348914supera_to_m
superblock2053204super_block
superblocks2152724superblocks
superbly1546984super_bl_y_
supercargoes1753944supercargoes
supercargos1654184supercargo_s
supercilious1664534supercilious
superclass1446624super_class
superclubs1644514super_clubs
supercools14106184super_cools
supercops1547734super__cops
superegos1246814super_ego_s
superflacks2252924superflacks
superfluids1753564superfluids
superglues1346464super_glues
superheroes1646534superheroes
superiors11410964super__iors
superlay1347754super__lay_
superlies11314554super__lies
superlong1247284super__long
supermales14410054supermal_es
supermoms1547304super__moms
supernations14410874supernations
superplanes1547434superplanes
superpros13137234super_pro_s
supersales12411244supersal_es
supersellers1453924supersellers
supersells1246464supersel_ls
supershows1845074super_shows
supervisors1653714supervisors
surreally1244814surreall_y_
suturally1245954suturall_y_

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.423422437.4
2DLD Change Limit148819498.54617413.9
3Display Results49490.0301633.3
 (SQL Overall)178691498.99919856.8
 
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.