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

63 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
trophying184471(None) 
atrophying1943531atrophying
trollying1354052trollying
trothing122410842troth_ing
biopsying1742453biopsying
copying153411983_cop_ying
cropping153210883crop_ping
dropping14309283drop_ping
frothing15208533froth_ing
graphing1538533graph_ing
groping113313103grop__ing
morphing1637553morph_ing
prepaying1747973prepaying
prophesying2253063prophesying
propining14310133propining
proponing1439993proponing
proposing1439673proposing
propping122811673prop_ping
repaying142712393_repaying
replying14269403_replying
roping94023023_rop__ing
stropping1436933strop_ping
stroying122410593stro__ying
taxpaying2242343taxpaying
toadying1335043t_oadying
toothing12278863tooth_ing
toping94122993t_op__ing
topping123514623t_op_ping
toppling13197353t_oppling
torching142510083torch_ing
toying105017303t_o__ying
trachling1537823trachling
trapesing1247263trapesing
trapping132911393trap_ping
trashing122613223trash_ing
trephine1338933treph_ine
trephining1644933trephining
tripling112712553trip_ling
tripping133210923trip_ping
trithing122811773trith_ing
troaking133310973tro_aking
trocking153612423tro_cking
troking123514103tro__king
trolleying1442553trolleying
trolling93212493tro_lling
tromping13319603tro_mping
trooping112710283tro_oping
trophic14311033troph_i_c
trophied1437643troph_ied
trophies13413673troph_ies
trophy1438283trophy___
tropin83316753trop__in_
tropine93116653trop__ine
tropins93116313trop__ins
troponin1047943troponin_
troponins1147203troponins
trotting92510913tro_tting
troubling1234943troubling
trouncing1235153trouncing
trouping11249503tro_uping
troweling1376363troweling
trowing113413703tro__wing
trying104214073tr___ying

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.453394461.4
2DLD Change Limit148641637.21620598.8
3Display Results63630.0331909.1
 (SQL Overall)178691637.70223200.6
 
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.