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

99 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
carbos10512226(None) 
carbo94923841carbo_
carbon104919041carbon
carbons115418941carbons
carboy134914181carboy
carboys144711781carboys
carbs96031461carb_s
cargos94619181cargos
carobs104818101carobs
abos67734412_a_bos
acarbose1244682acarbose
ambos95321252_ambos
arbor74818112_arbor
arbors84717882_arbors
arbs66834732_arb_s
arvos86015662_arvos
barbes104526232barbes
barbs95928192barb_s
cabob114616812ca_bob
cabobs124311892ca_bobs
cabs86739422ca_b_s
cacaos104616182cacaos
calos74431902ca_los
cameos105818002cameos
camos95927612ca_mos
campos125217952campos
cansos84915382cansos
cantos84826972cantos
capos94826072ca_pos
carabaos1238082carabaos
carats85929022carats
carb85143162carb__
carbora11310702carbora
carboras12311582carboras
cardon94120852cardon
cardons104519932cardons
cards85137932car_ds
carers85133962carers
cares77369182car_es
caress85720262caress
carets85330772carets
cargo85322072cargo_
cargoes104415222cargoes
carhop133610762carhop
carhops14329702carhops
caribes113715642caribes
caribou1156992caribou
caribous1258822caribous
caries85147622caries
carious93320282carious
carks115534212car_ks
carles85435082carles
carls77037422car_ls
carns75937562car_ns
carob95325222car_ob
carol75128612car_ol
carols85124982carols
carom95025562car_om
caroms105619572caroms
carps96932252car_ps
carpus105514302carpus
carrom10513402carrom
carroms11512402carroms
carrot8423122carrot
carrots9714622carrots
carrs75730852car_rs
cars67364762car__s
carses85233652carses
cartes86239472cartes
carton84522662carton
cartons94122472cartons
cartop104213562cartop
carts78946292car_ts
carves115128452carves
ceros74726072cer_os
charros124312142charros
claros84015112clar_os
combos125316612combos
crabs95421392crab_s
crambos1336782crambos
curbs94821652curb_s
curios83218332curios
darbs85323262darb_s
faros85532022far_os
garbs86321412garb_s
harbor11410722harbor
harbors12412412harbors
karoos102415802karoos
largos74815062largos
mambos125414492mambos
narcos86714202narcos
pareos87023772pareos
pargos95719042pargos
parvos116614752parvos
sambos104315192sambos
sargos74318272sargos
saros55238062sar_os
taros55640822tar_os
turbos8910782turbos

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit82551992.56332208.7
3Display Results99990.0303300.0
 (SQL Overall)178691992.91961216.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.