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 “dialyzing” 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
dialyzing234404(None) 
dialysing1444481dialysing
analyzing2245152analyzing
dialing94318172dial__ing
dialling10310782dial_ling
dialoging1246312dialoging
dualizing2047782dualizing
analysing1345933analysing
catalyzing2544773catalyzing
dairying1336353dairy_ing
dallying13368493d_allying
dazing175516513d_a__zing
dealing94323233deal__ing
deglazing2135133deglazing
delaying133210973delay_ing
diabolizing2444423diabolizing
diademing1454323diademing
dialings10329823dial__ings
diallings1134993dial_lings
dialoguing1342803dialoguing
dialysis1245413dialysi_s
dialytic1446803dialyti_c
dialyzate2242703dialyzate
dialyze2044433dialyz__e
dialyzed2243733dialyz_ed
dialyzer2143113dialyz_er
dialyzers2242783dialyzers
dialyzes2144503dialyz_es
diapering1339033diapering
diazin1639163dia__zin_
diazine1738933dia__zine
diazins1739183dia__zins
dilating102714903di_lating
diluting10248983di_luting
dirling93316073dirl__ing
dirtying1336093dirty_ing
disliking1537313disliking
divvying1932773divvy_ing
dizzying2133023dizzy_ing
dollying13407413dolly_ing
draying123813843dra_y_ing
finalizing2347983finalizing
gillying13306813gilly_ing
idealizing2147293idealizing
idolizing2046453idolizing
inlying1168153_inly_ing
mislying1437843misly_ing
paralyzing25185203paralyzing
realizing19313813realizing
vialing113614163vial__ing
vialling1237223vial_ling
vitalizing2348363vitalizing
waltzing2134263_waltzing
willying15306713willy_ing

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641547.36020195.8
3Display Results54540.0301800.0
 (SQL Overall)178691547.54623680.2
 
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.