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

42 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
recombinational21102021recombinational_
combinational1984083__combinational_
recombination19106173recombination___
recombinations2095593recombination__s
denominational1752544denom_inational_
combination17108805__combination___
combinations1897925__combination__s
declinational1652925dec__linational_
examinational2252185_exam_inational_
recompilation1955155recompilation___
recompilations2054955recompilation__s
renomination1499185renom_ination___
renominations15108305renom_ination__s
terminational1553485te_rm_inational_
accommodational2471556accommodational_
binational1246376_____binational_
bombination1765016__bombination___
bombinations1884596__bombination__s
combinatorial1961656__combinatorial_
commination171111646__commination___
comminations18810486__commination__s
compensational2073526__compensational_
computational1994576__computational_
denomination15118836denom_ination___
denominations16117856denom_ination__s
inclinational1553936inc__linational_
predomination1896536predom_ination___
predominations19105546predom_ination__s
prenomination17126756prenom_ination___
prenominations18105766prenom_ination__s
recombinant17133806recombina___n__t
recombinants18152666recombina___n_ts
recombining1844456recombin__i_n__g
recommendation2183226recommendation___
recommendations22113096recommendation__s
recomputation1974396recomputation___
recomputations20104106recomputation__s
recreational1455176rec___reational_
recrimination1757406recrimination___
recriminations1856726recrimination__s
reformational18113426refo__rmational_
renominating1546426renom_inati_n__g

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 Filter178691658740.1101624463.6
2DLD Change Limit65874426.03310918.9
3Display Results42420.060700.0
 (SQL Overall)178691426.20328807.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.