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 “misrepresentinga” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
misrepresenting2071431misrepresenting_
misrepresent16102924misrepresent____
misrepresented1971314misrepresent__ed
misrepresents17142204misrepresent___s
representing1555134___representing_
misapprehending2671165misapprehending_
copresenting1754946___copresenting_
misorienting15154966mis__or_ienting_
misprinting1646826mis__pr__inting_
misreporting1753236misrep___orting_
presenting131013026_____presenting_
reprehending1973476___reprehending_
derepressing1653577_derepres__sing_
disheartening1852387dishear_ten_ing_
disorienting14155657dis__or_ienting_
disrespecting1952437disre__specting_
dissenting121310297dis_____senting_
implementing1952707_i__mplementing_
interesting12411127_inte_res__ting_
intersecting1549717_inte_r_secting_
misaddressing1861427misaddres__sing_
misapprehension2481357misapprehensi_on
miscreating1648497mis__cr__eating_
misdirecting1853247mis_dir__ecting_
misesteeming1752887mis_este_e_ming_
mislearning1443727mislear___n_ing_
mismeeting1546247mis___me_e_ting_
mispainting1645297mis__p__ainting_
mispenning1545777mis__p___enning_
misperceiving2371447mispe_r_ceiving_
misplanting1645637mis__p__lanting_
mispointing1645797mis__p__ointing_
misreckoning2151917misre__ckon_ing_
misreferring1852397mis___referring_
misregistering1861527misre_gistering_
misrelating1447277mis___re_lating_
misremembering2071377misre_membering_
misrendering1683307misre__nde_ring_
misseating131310947mis_____seating_
missending1446497mis_____sending_
missetting13107907mis_____setting_
misspending1743657mis_sp___ending_
mistreating1449287mis__tr__eating_
mistrusting1465927mis__trus__ting_
mistrysting1774317mis__trys__ting_
precenting151012157_____precenting_
preprinting1647417__prepr__inting_
presetting131010837_____presetting_
preventing161210267_____preventing_
recementing1645227___re_cementing_
refreshening1952427___refreshen_ing_
regreening1246037___regre_en_ing_
regreeting1237347___regre_e_ting_
reorienting1246357___reor_ienting_
repenting122316557___rep___enting_
repigmenting1852587___repigmenting_
represent11410077___represent____
representable17102337___representable
represented1444117___represent__ed
representer1353617___represent__er
representers1452777___represent_ers
represents1246757___represent___s
repressing13310397___repres__sing_
reprinting131510587___repr__inting_
rerenting102617667___re_r__enting_
rerepeating1447187___re_repeating_
resenting102619297______resenting_
stepparenting18111087__stepparenting_
stepparentings1911917__stepparentings
supplementing2061837__supplementing_
unrepresented1661697_unrepresent__ed

Search took 10 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 Filter178691950240.360496363.9
2DLD Change Limit95024719.32610189.1
3Display Results71710.0461543.5
 (SQL Overall)178691719.73218361.2
 
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.