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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
carabao113967(None) 
carabaos1238071carabaos
carabid12311332carabid
carabin11313212carabin
caracal11312512caracal
caramba1336892caramba_
carapax1835792carapax
caravan1239222caravan
caraway1538132caraway
carbo94923842car_b_o
casaba1079262casaba_
casabas1139982casabas
curacao1146292curacao
acrobat11411813acrobat
anabas8314083_anabas
arabic10312733_arabic
arable81821003_arable
atabal839743_atabal
bacalao1146613bacalao
barbal104016663bar_bal
cabal95222153c__abal
cabala103516913cabala_
cabalas113516003cabalas
cabana103913563cabana_
cabanas112413033cabanas
cacao95420003c__acao
calabash1544253calabash
calabaza2143463calabaza
calamar1149293calamar
calando1037383calando
capable13313363capable
capably1639253capably
carabids1338183carabids
carabine12412383carabine
carabins12312353carabins
caracals12310743caracals
caracara1247243caracara
carack142113173cara_ck
caracks152211563caracks
caracol11310423caracol
caracul1138823caracul
carafe115416163cara_fe
carafes125015703carafes
caragana1146273caragana
caramel11310253caramel
carapace1446083carapace
carassow1343253carassow
carat75048793car__at
carate84734003cara_te
carates95630603carates
carats85929023cara_ts
caravans1338613caravans
caravel1238203caravel
caraways1636943caraways
carb85143163car_b__
carbarn1139453carbarn
carbon104919043car_bon
carbos105122263car_bos
carboy134914183car_boy
carbs96031463car_b_s
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715093cardias
cardio9915673car_dio
cargo85322073car__go
caribe103416743carib_e
caribes113715643caribes
caribou1156993caribou
carina84325323carina_
carinae94318583carinae
carinal94318223carinal
carinas93622383carinas
caritas93316943caritas
carload1039783carload
carman103920743car_man
carnal83919203car_nal
carnauba1252733carnauba_
carnaubas1342913carnaubas
carob95325223carob__
carobs104818103carob_s
carpal103716253car_pal
cartable121314093cartable
casava1157873casava_
casavas1237813casavas
casbah1337903ca_sbah
cassaba1145663cassaba_
cassabas1245733cassabas
catalo8314853cata_lo
catawba1443703catawba_
catawbas1544093catawbas
ceramal1138843ceramal
charabanc1842923charabanc
coranto9311893coranto
corban10314693cor_ban
craal74117753c_ra_al
crab85727673c_rab__
crabby15346753c_rabby
crabs95421393c_rab_s
crambo1238043c_rambo
cravat11314443c_ravat
curable112414513curable
curably142010773curably
curacaos1244923curacaos
curacoa1146223curacoa
curara83712203curara_
curaras93911943curaras
darbar959953dar_bar
faraday1445633faraday
faraway1645413faraway
gazabo1834833gazab_o
lavabo1135273lavab_o
marabou1147493marabou
maraca10314153maraca_
maracas11313773maracas
parable111819773parable
paramo102614643para_mo
rabat72832223__rabat
rabato83413263__rabato
saraband1146193saraband
scarab10310063scarab__
scarabaei1342063scarabaei
scarabs1137293scarab_s
tamarao977583tamarao
tarama8412723tarama_
taramas9612693taramas
zareba1736423zareba_
zarebas1836303zarebas
zariba1736973zariba_
zaribas1836043zaribas

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271307.57617691.0
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.79522923.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.