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

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

36 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
carabiniere155207(None) 
carabinier1444011carabinier_
carabinieri1551861carabinieri
carabiniers1552831carabiniers
carabineer1452992carabineer_
carabineers1552512carabineers
carabiner1346342carabin_er_
carabinero1452372carabin_ero
carabiners1445072carabin_ers
carabine12412393carabin___e
carabineros1551893carabin_eros
carabines13311473carabin_e_s
carbineer1344763car_bineer_
carbineers1444233car_bineers
jardiniere1851383jar_diniere
karabiner1543243karabin_er_
karabiners1642693karabin_ers
arabicize2254874_arabici_ze
arabinose1144064_arabin_ose
brainier102510234_bra_inier_
carabin11313214carabin____
carabins12312364carabin___s
caravaner1444744caravan_er_
caravaners1544144caravan_ers
caravanner1552644caravanner_
caravanners1652384caravanners
carbine112918644car_bin___e
carbines123617544car_bin_e_s
carbonize22169044car_boni_ze
crabbier14326804c_rab_bier_
grainier9218904_gra_inier_
harbinger1544124har_binger_
harbingered1851494har_bingered
harbingers1643944har_bingers
jardinieres1951294jar_dinieres
rainier71614264__ra_inier_

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819368.67317158.9
3Display Results36360.0132769.2
 (SQL Overall)178691369.10919617.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.