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

56 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
displanting154604(None) 
misplanting1645631misplanting
discanting1449452dis_canting
disparting1438932disp_arting
displacing1646412displa_cing
displaying1746312displa_ying
implanting1545322_implanting
misplanning1653872misplanning
cisplatin1344713cispla_tin_
cisplatins1444593cispla_tins
deplaning1338053d_eplan_ing
descanting1446923des_canting
desolating1239463desola_ting
dilating102714903di__la_ting
disbanding1545583dis_banding
disclaiming1744323disclaiming
discounting1547443discounting
disjointing2045293disjointing
dismantling1543393dis_mantling
dismasting1446383dis_masting
dismounting1545083dismounting
dispending1547923disp_ending
dispensing1448233disp_ensing
dispiriting1545943dispiriting
displant11412223displant___
displanted14126633displant_ed
displants1248073displant__s
displeasing1544933displeasing
disploding1575873displ_oding
displuming1644373displ_uming
disporting1439823disp_orting
dispraising1546043dispraising
disputing1337763disp__uting
disrating11714553dis_ra_ting
disseating121111783dissea_ting
dissenting121310293dis_senting
distancing1447083dis_tancing
distasting1248023dis_tasting
distracting1569253distracting
explanting2045223_explanting
islanding1135623_is_landing
isolating1039743_isola_ting
mispainting1645293mispainting
misparting1538083misp_arting
misplacing1745913mispla_cing
misplaying1845553mispla_ying
mispointing1645793mispointing
misprinting1646823misprinting
planting113515383___planting
preplanting1645933preplanting
reimplanting1752623reimplanting
replanting1338523_replanting
slanting94115093__s_lanting
splatting1235983__splatting
splinting1238193__splinting
supplanting1643923supplanting

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633565.26623097.8
3Display Results56560.0331697.0
 (SQL Overall)178691565.68931409.9
 
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.