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

57 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
bioregionalisms209166(None) 
bioregionalism1991791bioregionalism_
bioregionalists1891771bioregionalists
bioregionalist17112092bioregionalis_t
regionalisms1555063___regionalisms
bioregional1452184bioregional____
irrationalisms1664684_irrationalisms
regionalism1455544___regionalism_
regionalists1355814___regionalists
bioregions1362555bioregion_____s
biracialisms1853585bi_raci__alisms
emotionalisms17145325emo__tionalisms
irrationalism1555115_irrationalism_
irrationalists1464735_irrationalists
operationalisms1963715operationalisms
rationalisms14219485___rationalisms
regionalist1257225___regionalis_t
regionalizes2255845___regionalizes
virginalists16152835vi_r_gi_nalists
vocationalisms2163775_vocationalisms
bilingualisms18101886biling__ualisms
bioregion1252626bioregion______
bipedalisms1852696bi_pe___dalisms
biracialism1753966bi_raci__alism_
bohemianisms2161906b_ohemi__anisms
ceremonialisms20103206_cere_monialisms
emotionalism16185756emo__tionalism_
emotionalists15155826emo__tionalists
exceptionalisms28162536exceptionalisms
factionalisms20106366__factionalisms
fictionalises1855836fi__ctionalises
foreignisms1752196_fore_ign__isms
functionalisms2163986_functionalisms
imperialisms18105906_imperi__alisms
irrationalist1355816_irrationalis_t
nationalisms14259796___nationalisms
neorealisms1374886neore____alisms
nominalisms1555156_no__mi_nalisms
operationalism1864256operationalism_
operationalists1763886operationalists
orientalisms14105906__or__ientalisms
personalisms1676096___personalisms
professionalism22112716professionalism_
rationalises122010376___rationalises
rationalism131910236___rationalism_
rationalists121910066___rationalists
regionalistic1663096___regionalistic
regionalize2156106___regionali_ze
regionalized2355246___regionalized
regionals10286416___regional___s
revivalisms1953556___revi_valisms
sectionalisms1756526__sectionalisms
sensationalisms17274356sensationalisms
traditionalisms18113266traditionalisms
virginalist15153766vi_r_gi_nalis_t
vocationalism2054416_vocationalism_
vocationalists1964086_vocationalists

Search took 8 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.373479064.3
2DLD Change Limit95024577.44012772.0
3Display Results57570.0301900.0
 (SQL Overall)178691577.84322783.5
 
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.