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

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

43 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
controllerships2213202(None) 
controllership21182201controllership_
comptrollership2681203comptrollership_
containerships2163054cont_ainerships
controllers1344784controller____s
controversies1863344contro_vers_ies
consumerships2262885con__sumerships
containership2063145cont_ainership_
controller1245525controller_____
controversial1862655contro_vers_ial
copartnerships23132355copar_tnerships
councillorships2471515councillorships
censorships1854596cen_so___rships
chancellorships27101356chancellorships
coauthorships2392976coautho___rships
commanderships2671926co_mmanderships
comptrollers1851686comptroller____s
comradeships2262236co_mr_ade_ships
consulships1853066con__sul__ships
consumership2162966con__sumership_
controllability22121836controllability
controlled1345386controlle_____d
controlling1445426controll____ing
controlments1684446controlme___nts
controversy1952586contro_vers___y
controverters1852466contro_ver_ters
controverting1953366contro_ver_ting
controverts1654266contro_ver___ts
copartnership22112356copar_tnership_
corollaries1354996co__rollar__ies
cosponsorships2372086co_sponsorships
councillorship2371516councillorship_
counselorships2172216co_unselorships
doctorships1954446doct_o___rships
donorships1655156don__o___rships
followerships2461446fo_llo_werships
landownerships239976lan_downerships
mentorships1855186ment_o___rships
monitorships1953896monito___rships
motorships1746586mo_t_o___rships
nonmemberships2571336non_memberships
postmasterships24141826postmasterships
rulerships1554096____r_ulerships

Search took 9 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.1401276364.3
2DLD Change Limit95024438.12611693.8
3Display Results43430.0301433.3
 (SQL Overall)178691438.29621539.4
 
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.