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

35 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
surprizing224565(None) 
surprising1345621surprising
curarizing2247102curarizing
suberizing2247742suberizing
surprinting1444552surprinting
apprizing2347193_apprizing
comprizing2647463comprizing
disprizing2347923disprizing
misprizing2447533misprizing
outpricing1547003outpricing
overprizing2648033overprizing
prizing193514683___prizing
ruralizing2047883ruralizing
satirizing2058283satirizing
soberizing2246753soberizing
solarizing2048283solarizing
spritzing2135393s__pritzing
suberising1347423suberising
sulfurizing2453373sulfurizing
summarizing2544583summarizing
supersizing2347023supersizing
surfeiting1445023surfeiting
surmising1247683sur_mising
surpassing1343833surpassing
surplusing1353343surplusing
surprint1049533surpr__int
surprisingly18121723surprisingly
surprize1945843surpriz__e
surprized2144663surpriz_ed
surprizes2045593surpriz_es
surviving1644163sur_viving
suspiring1245703susp_iring
unsurprising1551753unsurprising
uprising1138953_u_prising
upsizing2035413_u_psizing

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 Limit140603356.23322557.8
3Display Results35350.0162187.5
 (SQL Overall)178691356.65526850.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.