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

33 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
preselected164396(None) 
preelected1545771pre_elected
reselected1345631_reselected
deselected1444082_deselected
praelected1544392pr_aelected
preerected1545572pre_erected
prelected1439122pr__elected
preselect1346982preselect__
preselects1464362preselect_s
reelected1238312_re_elected
nonselected1454383nonselected
prededucted1852333prededucted
preelect1249643pre_elect__
preelects1356083pre_elect_s
preenacted1544973pre_enacted
prereleased1452543prereleased
preselecting1744293preselecting
preselection16154883preselection
presented12311633pres__ented
presliced1435973pres_lic_ed
prosected14158633pros__ected
proselyted1643433prosel_yted
prospected1744873pros_pected
redefected1743853_redefected
reejected1955093_re_ejected
reerected1238613_re_erected
reflected1547983_re_flected
resected112514743_res__ected
reselect1059943_reselect__
reselects1156413_reselect_s
respected1438493_res_pected
selected1159783___selected
unselected1344973_unselected

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 Filter1786911216330.1561145455.1
2DLD Change Limit121633335.98320329.8
3Display Results33330.0162062.5
 (SQL Overall)178691336.15529031.8
 
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.