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

45 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
squiggling224188(None) 
smuggling1433242smu_ggling
sniggling1244412s_niggling
snuggling1243472snu_ggling
squegging2162502squegg_ing
squigglier2141592squigglier
giggling10227043__giggling
guggling10236353_gu_ggling
higgling14217163__higgling
jiggling18226363__jiggling
juggling18225603_ju_ggling
niggling11227443__niggling
quibbling2342823_quibbling
quilling182510003_qui_lling
quisling18218063_qui_sling
shingling14136973s_hingling
singling101913003s__ingling
slugging11339423slu_gg_ing
snugging11286933snu_gg_ing
sprigging1435893sprigg_ing
squabbling2442033squabbling
squalling1935173squ_alling
squealing1935153squ_ealing
squibbing2342753squi_bbing
squidding2143153squi_dding
squiggle1943183squiggl__e
squiggled2142453squiggl_ed
squiggles2052993squiggl_es
squiggliest2251693squiggliest
squiggly2242503squiggl__y
squilgeeing225983squilgeeing
squinching2542973squinching
squinnying2341843squinnying
squinting1936223squi_nting
squiring18177563squi__ring
squirming2143223squi_rming
squirreling21141743squirreling
squirting1934793squi_rting
squishing2234953squi_shing
straggling1344303straggling
struggling1342503struggling
swigging14337223s_wigg_ing
swingling14156203s_wingling
wiggling14217293__wiggling
wriggling1533813_wriggling

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 Filter1786911406030.406440125.6
2DLD Change Limit140603456.17022788.2
3Display Results45450.0162812.5
 (SQL Overall)178691456.59227107.3
 
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.