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

57 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
struggler1126455(None) 
straggler11377291straggler
struggle10345051struggle_
struggled12304301struggled
strugglers12273061strugglers
struggles11255281struggles
smuggler12244522s_muggler
straggle10359132straggle_
straggled12296852straggled
stragglers12305252stragglers
straggles11328502straggles
stragglier1243502stragglier
strangler10369472strangler
druggier11134833_druggier
juggler16418873__juggler
rugger84414513__rugg_er
scraggier1344133scraggier
scragglier1442283scragglier
scroggier1343133scroggier
shrugged1433673shrugg_ed
slugger93610683s_lugg_er
smugger11327053s_mugg_er
smuggle11265013s_muggle_
smuggled13254223s_muggled
smugglers13263433s_mugglers
smuggles12225443s_muggles
sniggler10396113s_niggler
snugger9318313s_nugg_er
snuggle9275713s_nuggle_
snuggled11234953s_nuggled
snuggles10306143s_nuggles
sprigger12366503sprigg_er
spriggier1343843spriggier
stagger94212393st_agg_er
staggier10167513st_aggier
straddler11205113straddler
straggly13355563straggl_y
stranger94715103strang_er
strangle98411503strangle_
strangled11268983strangled
stranglers11396823stranglers
strangles103011553strangles
stringer93812943string_er
stringier1036713stringier
stroller848173str_oller
stronger9349693strong_er
struggling1342503struggling
strummer1234783stru_mmer
strutter846503stru_tter
stumbler1235813st_umbler
toggler9399193_t_oggler
trigger9329163_trigg_er
truckler14297453_truckler
trudger9338733_trudg_er
trundler9256153_trundler
tugger84013103_t_ugg_er
wriggler13295263_wriggler

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.330541487.9
2DLD Change Limit148641578.15618224.7
3Display Results57570.0301900.0
 (SQL Overall)178691578.51620983.0
 
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.