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

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
larrigans104401(None) 
larrigan944211larrigan_
cardigans1345152cardigans
harridans13154562harridans
larrikins1343792larrikins
warrigals1343772warrigals
arraigns944353_arraig_ns
arrivals1145933_arrivals
arrogant949153_arrogant
artisans888523_artisans
barbicans1544483barbicans
bartisans1165553bartisans
bartizans2053703bartizans
cardigan1245613cardigan_
carriages1238333carriages
carrions10312453carri_ons
garrisons1043793garrisons
harijans1845723ha_rijans
harridan12145123harridan_
jerricans1883753jerricans
lacrimals1342913lacrimals
lagans75717783la___gans
lariats7615053la_ri_ats
larrikin1243793larrikin_
laryngals1342513laryngals
latrias71913213latri_a_s
ligans76817733l___igans
madrigals13856233madrigals
marriages1247383marriages
martians103111613marti_ans
marzipans2242643marzipans
origans839973__origans
parians93519733pa_ri_ans
partisans1167483partisans
partizans2055243partizans
ptarmigans1551583ptarmigans
saurians837763sauri_ans
tarragons1044483tarragons
wanigans1244743wa_nigans
wannigans1342393wannigans
warragals1343473warragals
warrigal1244313warriga_l

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 Filter1786911486410.420425454.8
2DLD Change Limit148641426.69022218.4
3Display Results42420.0133230.8
 (SQL Overall)178691427.12325086.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.