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 “underwrite” 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
underwrite144631(None) 
underwriter1553961underwriter
underwrites1545181underwrites
underwrote1445271underwrote
underbite1249812under_bite
underprice1545512underprice
underrate10411892under_rate
underripe1247832under_ripe
underwire1348122underw_ire
underwriters1652802underwriters
underwritten1652382underwritten
overwrite1579083_overwrite
underate9918603unde__rate
underbites1347893under_bites
underbrim1444633underbri_m
underbrims1544063underbrims
undergirt1147813undergirt_
underlie91413123under_li_e
underline101714673under_line
underlit91311533under_lit_
undermine122012233under_mine
underpriced1744613underpriced
underprices1644723underprices
underrated12310843under_rated
underrates11410563under_rates
underside11310143under_side
undersize1949513under_size
understate1148863understate
undertrick1754143undertrick
undervote1357753under_vote
underwater1446643underw_ater
underwent1349053underwent_
underwing141410883underw_ing
underwires1447023underwires
underwriting1754123underwriting

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.420425454.8
2DLD Change Limit140603356.18622729.2
3Display Results35350.0162187.5
 (SQL Overall)178691356.62226984.4
 
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.