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

105 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
cavalry155496(None) 
cavally1588481cavally
calvary1537182calva_ry
canary11314692cana_ry
cavalero1344762cavalero
cavalla1257882cavalla
chivalry1943082chivalry
covary1438742cova_ry
navally1366472navally
rivalry1354032rivalry
alary86123443_ala_ry
anally9513503_anally
aviary12338413_aviary
banally1249223banally
basally1237963basally
cabal95222153cabal__
cabala103516913cabal_a
cabalas113516003cabalas
cabals104020153cabal_s
caecally1547703caecally
cagily12411563cagil_y
cajolery20253573cajolery
calamary1545463calamary
calmly1337613calml_y
calory11312843ca_lory
canal75428043canal__
canaled103615553canaled
canals84421663canal_s
canard9314763cana_rd
cannery123610013cannery
canonry1235923canonry
capably1639253capably
caraway1538133caraway
carnally1339513carnally
carry105823783c__arry
casually1356823casually
casualty1344473casualty
catalo8314853catal_o
catalog1038003catalog
catalos9414163catalos
catalpa1136503catalpa
catarrh1245003catarrh
cattery123811603cattery
caudally1446463caudally
causally1356613causally
cautery12349573cautery
cavaleros1444093cavaleros
cavalier1348173cavalier
cavalierly1851603cavalierly
cavaliers1455613cavaliers
cavallas1366843cavallas
cavalries1446363cavalries
cavalryman2051153cavalryman
cavalrymen2051253cavalrymen
caver105629063cav_er_
cavern115312453cav_ern
cavers115026833cav_ers
caviar11310163caviar_
caviare1238373caviare
caviars1238623caviars
cavil103816493cavil__
caviled1348723caviled
caviler1249063caviler
cavilers1348113cavilers
cavils114014393cavil_s
cavitary1664963cavitary
cavity14310013cav_ity
cavort11316173cav_ort
cavy125920003cav___y
cecally1459393cecally
cedary12419603ceda_ry
chalky18468773c_halky
chally144314293c_hally
charry145012113c_harry
chary135023133c_ha_ry
civilly1535483civilly
clary105719613c_la_ry
clearly1236663clearly
coaly105521593c_oal_y
coevally1646283coevally
coxalgy2042603coxalgy
datary10310243data_ry
devilry1433973devilry
fatally1339893fatally
lavatory1445693lavatory
nasally1057443nasally
naval85315833naval__
navar83912733nava_r_
navars92810573nava_rs
ovally12278443_ovally
ovary1149113_ova_ry
papally1437973papally
ravelly13268353ravelly
revelry1335693revelry
salary9515213sala_ry
savagery1543223savagery
saveloy1334663saveloy
savory124310563sav_ory
savoury13365873savoury
vagally1435833vagally
vagary1337333vaga_ry
vary105226063__va_ry
vivary1536983viva_ry
wavery154610053wav_ery
wavily15219483wavil_y

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.190940478.9
2DLD Change Limit1340271057.07618941.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.31224438.0
 
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.