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

80 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
marabou114749(None) 
marabous1249061marabous
marabout1249111marabout
caribou1156992caribou
marabouts1364962marabouts
acajou1595233_acajou
amadou977613_amadou
arabic10312733_arabic
arable81821003_arable
arbor74818113_ar_bor
arbour84211333_ar_bour
carabao1139673carabao
carabaos1238083carabaos
carabid12311333carabid
carabin11313213carabin
caracol11310423caracol
carbo94923843car_bo_
carbon104919043car_bon
carbos105122263car_bos
carboy134914183car_boy
carcajou19123583carcajou
caribous1258823caribous
farebox1943823farebox
gadabout1245563gadabout
gazabo1834833gazabo_
gazabos1944453gazabos
harbor11410723har_bor
harbour1247053har_bour
lavabo1135273lavabo_
lavabos1235453lavabos
layabout1345163layabout
macaber1336163macaber
macabre1335223macabre
macaco1247853macaco_
macacos1338083macacos
maccaboy1942513maccaboy
magalog1144913magalog
mailbox1853563mailbox
makable15510203makable
mambo115215743ma_mbo_
mambos125414493ma_mbos
manitou938463manitou
mara67444573mara___
maraca10314153mara_ca
maracas11313773maracas
maranta9311693maranta
maras75443293mara__s
marasca1136823marasca
marasmus1244473marasmus
marathon1346823marathon
maraud938943mara_ud
marauds1037553marauds
marble104219103mar_ble
marbly134111933mar_bly
marcato1139743marcato_
marcatos1249163marcatos
markhor1635463markhor
marmot10318743mar_mot
maroon83118203mar_oon
marplot1149673marplot
marrano939423marrano_
marranos1038423marranos
marron83717543mar_ron
marrow112812613mar_row
martagon1145273martagon
matador1066253matador
miaou7513083m_ia_ou
mirador1046503mirador
parable111819773parable
parabola1246653parabola
parador103311413parador
parados103816053parados
paradox17358173paradox
paragon10311023paragon
paramo102614643paramo_
paramos113213513paramos
paramour1246083paramour
parasol939553parasol
sapajou1643693sapajou
turacou945513turacou

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 Filter1786911340270.393454684.5
2DLD Change Limit134027806.21621561.6
3Display Results80800.0332424.2
 (SQL Overall)178691806.64226903.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.