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

58 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
underplot124682(None) 
underplots1345401underplots
underflow1643942underflow
underfoot1347032underfoot
underlet91516212under_let
underlit91311532under_lit
underpart1288512underpart
underplay1545192underplay
underprop1444352underprop
undershot1346892undershot
counterplot1596813counterplot
overplot1338543_overplot
underact11311513under_act
underclad1345563underclad
underclay1545063underclay
undercoat1248733undercoat
undercook1644923undercook
undercool1245533undercool
undercroft16154963undercroft
undercut1148663under_cut
underdo937363under_do_
underdog1145353under_dog
undereat9313903under_eat
underflows1743943underflows
undergirt1147813undergirt
undergo937043under_go_
undergod1136583under_god
underheat1348383underheat
underlap11146423under_lap
underlay12147653under_lay
underlets10158893under_lets
underlie91413123under_lie
underlip11157203under_lip
underload1146373under_load
undermost1247963undermost
underpaid1346963underpaid
underpants1346913underpants
underparts1346113underparts
underpass12136783underpass
underpay14136213underp_ay
underpays15166113underpays
underpin1138843underp_in
underpins1239733underpins
underplays1644653underplays
underproof1643573underproof
underprops1554413underprops
underset91417133under_set
undershoot1445103undershoot
undersold1146883undersold
undertint10414863undertint
undertook1445093undertook
undertow1266233under_tow
undervest1398673undervest
undervote1357753under_vote
underwent1349053underwent
underwood1446473underwood
underwool1345013underwool
underwrote1445273underwrote

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 Filter1786911486410.436409841.7
2DLD Change Limit148641586.23323847.4
3Display Results58580.0163625.0
 (SQL Overall)178691586.68526730.1
 
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.