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

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

55 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
karoo9251958(None) 
karoos102415801karoos
karroo10410011karroo
kazoo183311531kazoo
arco68331542_arco
arvo76023432_arvo
baboo94319502baboo
baron78131242baron
bazoo163815672bazoo
broo65129822_broo
carbo94923842carbo
cargo85322072cargo
carob95325222carob
carol75128612carol
carom95025562carom
faro76136922far_o
faros85532022faros
gazoo153112872gazoo
kabob134113932kabob
kaon87521022ka_on
kapok10448782kapok
karat96837592karat
karma113415002karma
karn86129412kar_n
karns96624142karns
kaross101910012kaross
karroos1139312karroos
karst97228992karst
kart86750802kar_t
karts97630112karts
kayo116417552ka_yo
kayos127714702kayos
kazoos19259112kazoos
kroon94514482k_roon
largo65319782largo
maroon83118202maroon
narco76718242narco
pareo74632602pareo
pargo86723722pargo
parol74826272parol
parvo107719182parvo
sargo65424412sargo
sarod65325872sarod
saros55238062saros
taboo73418092taboo
tardo65321102tardo
taro46846912tar_o
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
varoom11411412varoom
wahoo112413082wahoo
wazoo173011172wazoo
yahoo112911542yahoo

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800551.56334421.0
3Display Results55550.0163437.5
 (SQL Overall)178691551.87595301.9
 
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.