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

76 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
capric12411792capr_ic
capris10415072capr_is
captain112111052captain
cardio9915672ca_rdio
afraid1049713_afraid
apraxia1646893_apraxia
apraxic1846293_apraxic
barrio8312573ba_rrio
cacao95420003ca_ca_o
calpain11310413calpain
camail10314823ca_mail
cantraip12326383cantraip
caparison1343983caparison
capelin11510973capelin
capias10318353capia_s
capiz18514563cap__iz
caplin103216303cap_lin
capo85829213cap___o
caporal11410943capora_l
caporals1238923caporals
capriccio1452083capriccio
caprice1349683caprice
caprifig1643223caprifig
caprine11314233caprine
capriole1276913capr_iole
caprock1736813caprock
capsid11312413cap_sid
captains121810573captains
captan101613343capta_n
captans111612053captans
caption113513693cap_tion
carabao1139673ca_rabao
carabid12311333ca_rabid
carabin11313213ca_rabin
carack142113173ca_rack
caracol11310423ca_racol
carafe115416163ca_rafe
carat75048793ca_ra_t
carate84734003ca_rate
carats85929023ca_rats
carbo94923843ca_r_bo
cardia9916373ca_rdia
cargo85322073ca_r_go
carlin84421823ca_rlin
carnie84421093ca_rnie
carpaccio1452293carpaccio
carpal103716253carpa_l
carpale113414353carpale
carpalia1247253carpalia
carpals113414623carpals
carpi94319393ca_rpi_
carrack1548753carrack
carrion9312673ca_rrion
castrato1048523castrato
catalo8314853ca_talo
cattail939173cattail
cattalo938423cattalo
chaplain1546193chaplain
charpai1436623charpai_
charpais1536923charpais
copra98115463copra__
coprah133710603copra_h
coprahs14338153coprahs
copras103517153copra_s
cupric1249113cupr_ic
curio74221203c_ur_io
cyprian1445343cyprian
farrago1144923farrago
marrano939423marrano
papain10313793pap_ain
paramo102614643pa_ramo
prao66229023__pra_o
sapsago1044303sapsago
soprano937003soprano
sprain83614863_sprain
tapalo839793tap_alo

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.1561145455.1
2DLD Change Limit134027767.11018850.5
3Display Results76760.0332303.0
 (SQL Overall)178691767.29924481.6
 
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.