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

81 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
cavil10381649(None) 
cavie104621591cavie
cavils114014391cavils
civil103411931civil
ail37171052_a_il
anil46437432_anil
anvil82712602anvil
aril45843022_aril
avail8313882_avail
avid88325972_avid
axil116424452_axil
bail65042802ba_il
basil75122272basil
cabal95222152cabal
cabin94820942cabin
cadi75732192cadi_
cadis84428502cadis
cagily12411562cagily
caid77837542ca_id
cain65643912ca_in
calif104929102calif
calix145317352calix
call66838672ca_ll
camail10314832camail
camel96822802camel
canal75428042canal
canid85526342canid
capiz18514562capiz
carl65144782ca_rl
carol75128612carol
carvel114817572carvel
caul65630002ca_ul
cave95941262cav_e
caved116227562caved
caver105629062caver
caves105639702caves
caviar11310162caviar
cavies114525002cavies
caviled1348722caviled
caviler1249062caviler
caving124822612caving
cavity14310012cavity
cavy125920002cav_y
ceil65725062c_eil
civic123412542civic
civie103716352civie
clavi104912922clavi_
coil66439652c_oil
covin105621122covin
davit93424592davit
devil94714732devil
ervil8310302ervil
evil75318072_evil
fail74840242fa_il
gavel95815182gavel
gavial10310082gavial
hail74839062ha_il
jail115529092ja_il
kail85131502ka_il
kevil12399862kevil
mail65543452ma_il
mavie104722562mavie
mavin105722952mavin
mavis105622722mavis
nail45838652na_il
naval85315832naval
navel87016572navel
pail66141832pa_il
pavid115717002pavid
pavin105623202pavin
pavis106422732pavis
rail46147762ra_il
ravel84621512ravel
ravin85624652ravin
sail45447162sa_il
savin84625082savin
tail45443652ta_il
vail75432552va_il
vakil1259792vakil
wail75238822wa_il
wavily15219482wavily

Search took 4 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 Filter178691538000.626285448.9
2DLD Change Limit53800813.15617046.9
3Display Results81810.0302700.0
 (SQL Overall)178691813.81246875.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.