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

54 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
swaggerer144294(None) 
staggerer1143921staggerer
swaggered1543191swaggered
swaggerers1542231swaggerers
saggered11237552s_aggered
sniggerer1142722sniggerer
staggered1244472staggered
staggerers1242932staggerers
swagger12389332swagg__er
swaggers13407222swagger_s
wagerer11328492_wa_gerer
daggered12246403_daggered
eagerer8248823_ea_gerer
jaggeder1842783_jaggeder
raggeder1143263_raggeder
saggared11326063s_aggared
sagger84321073s_agg__er
saggers94017083s_agger_s
saggier92912063s_agg_ier
scamperer1544623scamperer
scatterer11186293scatterer
shaggier13116053shagg_ier
shatterer12177203shatterer
slaggier10126953slagg_ier
slanderer1046673slanderer
slaverer11196993sla_verer
smatterer11185813smatterer
snaggier10136303snagg_ier
sniggered1243443sniggered
sniggerers1242193sniggerers
stagger94212383stagg__er
staggers10379843stagger_s
staggery13346243stagger_y
staggier10167513stagg_ier
stammerer1344063stammerer
swager104013613swa_g__er
swagers114211023swa_ger_s
swagged13419143swagg__ed
swaggering16233623swaggering
swaggie12135783swagg_ie_
swaggies13136693swagg_ies
swigger12338453swigg__er
swiggers13337123swigger_s
wagered12299333_wa_gered
wagerers12247613_wa_gerers
wagger113616013_wagg__er
waggeries14127463_waggeries
waggers124613083_wagger_s
waggery15276903_wagger_y
wagglier1344323_wagglier
waggoner1343413_waggoner
wanderer122210123_wanderer
waterer103314073_wa_terer
waverer13319523_wa_verer

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit148641548.17318186.8
3Display Results54540.0301800.0
 (SQL Overall)178691548.37621333.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.