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

45 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
controllerships22132021controllerships_
controllership21182202controllership__
comptrollership2681204comptrollership__
containerships2163055cont_ainerships_
controllers1344785controller____s_
controversies1863345contro_vers_ies_
consumerships2262886con__sumerships_
containership2063146cont_ainership__
controller1245526controller______
controversial1862656contro_vers_i_al
copartnerships23132356copar_tnerships_
councillorships2471516councillorships_
censorships1854597cen_so___rships_
chancellorships27101357chancellorships_
coauthorships2392977coautho___rships_
commanderships2671927co_mmanderships_
comptrollers1851687comptroller____s_
comradeships2262237co_mr_ade_ships_
consulships1853067con__sul__ships_
consumership2162967con__sumership__
controllability22121847controllabili_ty
controlled1345387controlle______d
controlling1445427controll____i_ng
controlments1684447controlme___nts_
controversially2381487contro_versially
controversy1952587contro_ver____sy
controverters1852467contro_ver_ters_
controvertible21101837contro_ver_tible
controverting1953367contro_ver_ti_ng
controverts1654267contro_ver___ts_
copartnership22112357copar_tnership__
corollaries1354997co__rollar__ies_
cosponsorships2372087co_sponsorships_
councillorship2371517councillorship__
counselorships2172217co_unselorships_
doctorships1954447doct_o___rships_
donorships1655157don__o___rships_
followerships2461447fo_llo_werships_
landownerships239977lan_downerships_
mentorships1855187ment_o___rships_
monitorships1953897monito___rships_
motorships1746587mo_t_o___rships_
nonmemberships2571337non_memberships_
postmasterships24141827postmasterships_
rulerships1554097____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.343520965.0
2DLD Change Limit95024458.15611650.8
3Display Results45450.0301500.0
 (SQL Overall)178691458.52920951.0
 
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.